Hello All:

I am trying to copy tables from one sql server 2000 database to another but
it errors out due to a column data coversion error.
The source table has a column (birthday, nvarchar) in it, with example of
data in it being 12121997. the destination column is (birthday, Datetime).
I get error :

Server: Msg 8115, Level 16, State 2, Line 1
Arithmetic overflow error converting expression to data type datetime.
The statement has been terminated.

How can i make DTS convert this nvarchar column to datetime and to recognize
the source data as valid when importing into the destination table.

Thanks,

Tunji

I think Aaron answered this on another NG. please do not X post like this.
if you want to send to more than one NG then include them all in the To
list.

See Aaron's reply.

--


Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

That's is true! Sorry.

Thanks!

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote