insert data into a table
Posted on 2009-02-09
We are on Great Plains version 8. Someone (me) mistakenly deleted 3 years of history of orders from the order headers table. these are linked ot the order details table.
So I am trying to insert this data from a backup into the production system table through DTS.
The error I am receiving is: Primary Key Violation, cannot insert duplicate key into SOP30200 with primary key of "Error 0xc0202009: Data Flow Task: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "The statement has been terminated.".
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Cannot insert duplicate key row in object 'dbo.SOP30200' with unique index 'AK2SOP30200'.".
(SQL Server Import and Export Wizard)"
I have looked for the duplicate order but cannot find it.
The primary key is on the Order number.
Any help out there???