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