Hi, I want to transfer datetime values from a table to an other. Both are in the same database. I'm using SSIS packages. The OLE DB Source contains a SQL script like "SELECT DATE_CREATION FROM my_table". When I start the transfer by myself, it goes well. But sometimes, when the job executing the package runs, I have this following error message : "There was an error with input column "DATE_CREATION" (164) on input "OLE DB Destination Input" (29). The column status returned was: "Conversion failed because the data value overflowed the specified type.". " When I check the "Advanced Editor for OLE DB Destination", the DataType is "database timestamp [DT_DBTIMESTAMP]" for the External Column "DATE_CREATION" and "DT_DBTIMESTAMP" for the Input Column. How can I detect the error ? Thank you in advance for your help !

Do you insert the data into another table which has DATETIME datatype? What is a datatype of the DATE_CREATION column?Best Regards,Uri Dimant SQL Server MVP,http://sqlblog.com/blogs/uri_dimant/ Blog : MS SQL Development and Optimization Blog : Large scale of database and cleansing

The documentation isn't really clear, but I think dates start at 30 December 1899 (not sure what the maximum is), so you need to check if there are any outliers in your data. Add some error handling to your dataflow that redirects the errors rows to a flat file, so that you can inspect those.MCTS, MCITP - Please mark posts as answered where appropriate.

The documentation isn't really clear, but I think dates start at 30 December 1899 (not sure what the maximum is), so you need to check if there are any outliers in your data. Add some error handling to your dataflow that redirects the errors rows to a flat file, so that you can inspect those.MCTS, MCITP - Please mark posts as answered where appropriate.

in the data flow, you can redirect the errorneous rows to another table or file, based on your need. http://www.rad.pasfu.com/index.php?/archives/23-How-to-handle-Failed-Rows-in-a-Data-Flow.html regards joon