SSIS Error with Column
Jul 6, 2022
Situation: We do migration from SSIS 2016 to 2019, and then deploy package is successful. However, the error happened when execute…
Error Msg:
[Oracle Source XXX] Error: SQLSTATE 22018, Message: [Microsoft][ODBC Oracle Wire Protocel driver]Invalid charater value. Error in column XXX.;
[Oracle Source XXX] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "Oracle Source.Output[Oracle Source Output]" failed because error code 0xC020F450 occurred, and the error row disposition on "Oracle Source"...
Cause: The metadata of SSIS package is wrong, it must update!
Solution:
Open error occurred component -> choose “Connection Manager” and “Columns”, and click something. Then, metadata would be refreshed!(MAGIC!!) -> Check error sign if disappear -> Save it
REF: