DTS Imports | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

DTS Imports

I am trying to import some tables from access into sql server. One of the fields (Long Date and Time field) will not import into SQL Server. It comes up with the following error: Error at Destination for row number 1. Errors encountered so far in this task: 1. Insert error, coloum 12 (‘fldtime’, DBTYPE_DBTIMESTAMP), status 6: Data overflow. Invalid character value for cast specification. Has anyone come across this before? If yes, how did you manage resolve it? Jason Quail
Well, it sounds like it is not getting a valid entry for time field so it is putting in null time or something. I suggest to test import file and diddle with formatting until one worked. Check whether correct data types are created on the table when using DTS.
Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
You must change all smalldate to datetime datatype using Transform feature of DTS.
That will correct your problem.