Datalfow error detination input failed with error code 0xC020907B


  • I am getting this error msg.

    [OLE DB Destination [83]] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR.  The "input "OLE DB Destination Input" (96)" failed because error code 0xC020907B occurred, and the error row disposition on "input "OLE DB Destination Input" (96)" 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.

    i don't see any id with 96,   how do i find, which column  pointing to input "OLE DB Destination Input" (96) 



    • Edited by Vaishu Sunday, September 09, 2012 1:54 PM correction
    Sunday, September 09, 2012 1:47 PM


  • (96) is the lineage id of the input column. So if you look at advanced properties of the Ole Db Destination component and look under input columns you should get the column name. On a separate note, there will be other related warning/ error messages alongwith the above error which should give you more information about the error. Those messages will be more helpful.

    • Marked as answer by Eileen Zhao Monday, September 24, 2012 7:38 AM
    Sunday, September 09, 2012 4:41 PM

All replies