none
Datalfow error detination input failed with error code 0xC020907B

    Question

  • 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) 


    Thanks

    V


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

Answers

  • (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.


    http://btsbee.wordpress.com/

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

All replies

  • If it is in the Data Flow Task, then just double-click it and then hit F4, then drop down the list of elements until you see name "OLE DB Destination Input". This is easier than searching by ID.

    As to the error, it is possible that you use transactions in a sequence container thus this Connect item's workaround may help: http://connect.microsoft.com/SQLServer/feedback/details/573638/ssis-package-failes-with-ole-db-error-when-using-transaction-support-on-sequence-container 


    Arthur My Blog

    Sunday, September 09, 2012 4:41 PM
    Moderator
  • (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.


    http://btsbee.wordpress.com/

    • Marked as answer by Eileen Zhao Monday, September 24, 2012 7:38 AM
    Sunday, September 09, 2012 4:41 PM
  • Regarding error 0xC020907B.  I've gotten that while trying to transfer a NULL value to something that doesn't like nulls.

    {-|-}

    Tuesday, September 03, 2013 5:40 PM