John Rowan (10/5/2015)
Number(38) is much larger than integer and I don't think they play nice together with implicit conversions. The error looks like it's happening on your destination component so I'm guessing that you have not done an explicit data conversion on these values. You're going to need to get those Number(38)'s into an integer somehow. This will likely be a Data Conversion transformation depending on the SSIS data type that the column has. A derived column could be used as well if you need to use an expression on the data to trim it down. Number(38) may be the source data type, but what data type do these values show up as in the SSIS pipeline for your data flow?
Quick thought, Oracle's NUMBER(38) only mapps to SQL Server's NUMERIC(38), no other mapping will work.
😎