DTS Import datetime field problem from Flat File SQL2000
Posted on 2006-06-25
I am trying to import large flat files into my Table using DTS.
The import always failed due to the Date fields error:
TransformCopy 'DirectCopyXForm' conversion error: Conversion invalid for datatypes on column pair 27 (source column 'Col027' (DBTYPE_STR), destination column 'last_modified' (DBTYPE_DBTIMESTAMP))..... and so on for the other date fields that are in my table.
My current solution, is to convert those fields to varchar and then import the file, then reconvert them back to datetime. It works, but there has to be a better way, a right way to fix this problem??