Ssis - Intermittent Error "conversion Failed Because The Data Value Overflowed The Specified Type."

I have an SSIS package which intermittently fails with a handful of errors, the two most informative of which are: DFT_PlaySummary SSIS Error Code DTS_E_OLEDBERROR. An OLE DB e

Solution 1:

Two options you can try,

1. Use Data Conversion in Data flow task to convert necessary values.
2. Set specific data types in derived column itself, if your column is available there.

Data conversion is handy when this type of error occurs commonly.

SSIS date time format should be used correctly. The below article explanins difference clearly. Use the correct format, which is required for you.

http://consultingblogs.emc.com/jamiethomson/archive/2005/11/15/SSIS_3A00_-What_2700_s-the-difference-between-DT_5F00_DATE-and-DT_5F00_DBTIMESTAMP.aspx