error code 0xC020907B
Once a while you encounter mysteries that suddenly appear without any known reason. A customer has a once a year scheduled SSIS package running in the Sqlserver manager. Executing the job after a full year results in an error.
Examining the dataflow we conclude the error happens pushing its data to the OLE-Dbconnection component. This component is directing its output to a table. We see the following error messages while debugging the SSIS package.
[Stage [28]] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR.
The "Stage.Inputs[OLE DB Destination Input]" failed because error code 0xC020907B occurred,
and the error row disposition on "Stage.Inputs[OLE DB Destination Input]" specifies failure on error.
The solution was to trash the OLE-DB component and then add it again. It definitely has to do with column definitions that were done on the table and created inconsistency with the table definition in the OLE-db component.
Replacing the component solved the problem and the packages was running as usual.