SSIS Error

  • Im moving data from oracle to sql 2008 r2

    and getting the following error

    [OLE DB Destination [1549]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E2F.

    An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80040E2F Description: "The statement has been terminated.".

    An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80040E2F Description: "The INSERT statement conflicted with the FOREIGN KEY constraint "R_5". The conflict occurred in database "ReportServer", table "dbo.PROPERTY", column 'PROPERTY_ID'.".

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

    [Oracle Source [1]] Error: Failed to add row to output buffer.

    Any suggestions...

  • You've got some dependency on R_%

    "The INSERT statement conflicted with the FOREIGN KEY constraint "R_5""

    Temporarily disable the constraint so you can move the data or you can also try using the OLEDB provider instead of the Native Client (doubt that will work)

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

  • This is the issue " The statement has been terminated.The INSERT statement conflicted with the FOREIGN KEY constraint "

    You are trying to insert a value in your table which doesn't exist in the parent (primary ) table.

    --

    SQLBuddy

  • thanks guys... i had found the source data has some quality issuess. But for loading data i was using oledb

    Shaun

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply