Error at Destination for Row number 82696. Errors encountered so far in this task: 1. Insert error, column 16, ('Birth_Dt', DBTYPE_DBTIMESTAMP), status 6: Data overflow. Invalid character value for cast specification.Any suggestions on how to resolve this issue?
If you're using DTS/SSIS, I suggest you perform a transformation on the column to convert it to VARCHAR of the appropriate length and make sure the target column on SQL Server is of the DATETIME data type. It should work fine from there since SQL Server will do an implicit conversion of any string data type to DATETIME.
Do you have comments on this Ask the Expert Q&A? Let us know.
Dig Deeper on Microsoft SQL Server Installation
Related Q&A from Kevin Kline
Monitoring and Administration expert Kevin Kline discusses the obstacles of database administration when a publisher resides on a different domain. Continue Reading
A common SQL Mail error is addressed by monitoring and administration expert Kevin Kline. Continue Reading
Monitoring and Administration expert Kevin Kline discusses the installation of SQL Server client tools on Windows XP Pro. Continue Reading