Unanswered: Error at Destination for Row xx Data overflow. Invalid Character value for cast spec
I am receiving this error message when using DTS to import data from an Access db to SQL:
Error at Destination for Row number 18409. Errors encountered so far in this task: 1.
Insert error, column 1 ('Date'), DBTYPE_DBTIMESTAMP), status 6:
Invalid Character value for cast specification.
I have deleted 10 rows before 18409 and 10 rows after 18409 and the error message when trying to import is always the same, same row number. The datatype in Access is Date/Time and in SQL Server it is datetime Length 8 allow nulls. I have tried changing Access datatype to Text and SQL to VarChar and still same error exact error message. I am not sure where to go from here. Any help / suggestions would be greatly appreciated!! Thanks!