I have created a DTS package which contains a datetime field. When I execute the package I get the following error message reference to the incorrect date type.
The number of failing rows exceeds the maximum specified.
TransformCopy 'DirectCopyXform' conversion error: General conversion failure on column pair 9 (source column 'dispatch' (DBTYPE_DBDATE), destination column 'dispatch'(DBTYPE_DBTIMESTAMP)).
The 'dispatch' column is the datetime column I am having the problem with.
The number of failing rows exceeds the maximum specified.
TransformCopy 'DirectCopyXform' conversion error: General conversion failure on column pair 9 (source column 'dispatch' (DBTYPE_DBDATE), destination column 'dispatch'(DBTYPE_DBTIMESTAMP)).
The 'dispatch' column is the datetime column I am having the problem with.