Thursday, March 22, 2012

DTS error

Hi,

I am transferring data from sybase to MS Sql server(using DTS) and it transferred all the tables correcty except for one table for which it says

error at destination rownumber 20. Errors encountered so far in this task 1,
Insert error column 36(last_purchase_date,dbtype_dbtimestamp)status 6, dataoverflow invalid character value for cast speicification

Can you please tell what cud be causing this error and how cud we get rid of it.

Thanks & RegardsIt might be a data error...switch off the fast load option for this and try doing it with error logging on and see what comes out in the log file.

No comments:

Post a Comment