Error 0xc0202009: Data Flow Task 1: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005


Question: How do you solve for this error? 

Error 0xc0202009: Data Flow Task 1: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available.  Source: "Microsoft SQL Server Native Client 11.0"  Hresult: 0x80004005  Description: "The statement has been terminated.".
An OLE DB record is available.  Source: "Microsoft SQL Server Native Client 11.0"  Hresult: 0x80004005  Description: "The INSERT statement conflicted with the FOREIGN KEY constraint "FK_SomeValue". The conflict occurred in database "DatabaseName", table "dbo.tableName", column 'id'.".


Login to See the Rest of the Answer

Answer:
Import one table at a time, it showing you that one table has a foreign key that references another table, data import will not go through until that
table is imported first. Best way to resolve this issue is to identify the table that has a referenced Foreign key then importing that table first, followed by the table
that has the Foreign Key (referencing the other table).

 


SQL
published
v.0.01




For peering opportunity Autonomouse System Number: AS401345 Custom Software Development at ErnesTech Email AddressContact: [email protected]