Monday, March 19, 2012

DTS package insertion error

hi frnds,

im very new to DTS package.

i had created the DTS package in SQL Server 2000 to read from the textfile and to populate the values in DB.

Source file is text file(delimited file with | as delimiter), destination is DB.

while inserting the records in DB . im getting the error as :

Transformcopy DTS transformation _ 1 conversion error : conevrsion invalid for datatypeson column pair 1 (Source column 'Col022(DBTYPE_STR),destination column usr_nct_timestp(DBTYPE_DBTIMESTAMP)

but i dont hvae NULL values in any of the cols.

please help me .

thnkx in advance. its urgent.

Try posting this in the DTS forum:

http://groups.google.com/group/microsoft.public.sqlserver.dts?lnk=srg

No comments:

Post a Comment