Showing posts with label frnds. Show all posts
Showing posts with label frnds. Show all posts

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