SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR

Question

I got this strange error message I couldn't get rid of no matter what i tried. It is an SSIS package developed using Visual Studio Prof. 2012 and database is SQL Server 2012.

Message reads this:

[OLE DB Source [85]] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "OLE DB Source.Outputs[OLE DB Source Output].Columns[ProductionMultp]" failed because error code 0xC0209075 occurred, and the error row disposition on "OLE DB Source.Outputs[OLE DB Source Output].Columns[ProductionMultp]" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure.

This happens at the time of creating source data in OLE DB Source Editor. I tried to convert source data to the right data type needed in the destination within the source sql command, I tried to the conversion using Data Conversion tool in SSIS, I tried to use both with no avail...

Anybody familiar with that sort of message???

By the way, there is no NULLs in the data nor any value is greater than allowed number of digits in given data type...

Answer 1

Go to Advanced Editor for OLE DB Source by right clicking on 'OLE DB Source' / 'Show Advanced Editor...'. Go to the tab 'Input and Output Properties' and expand the option 'OLE DB Source Output' then expand 'Output Columns'. Find your field that is mentioned in the error message and click on it. On the right hand side 'Common Properties' show, find Data Type Properties / Data Type and Length there. Change the data type to what needs to be for that field. That worked fine in my case, I hope it helps you too.