August 17, 2012 at 2:06 pm
I am trying to insert values from source to destination and i ma getting the following error.What should be the solution to this???
[Destination 13 - QuoteAdditionalPlan [1603]] Error: 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.BRASS_QuoteAdditionalPlan' with unique index 'NK_QuotelAdditionalPlan'. The duplicate key value is (628091, 101 CHARS, 1, 12345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901, Life, R)."
August 22, 2012 at 12:24 pm
The error message is quite clear.....please check the unique index constraint 'NK_QuotelAdditionalPlan' on your table. Basically some key value or values(if it happens to be a composite key) are coming withn the same value(s) as already present in the table.
The solution is really about a paradigm followed in the ssis domain :
Have a stage table where you bring in all your data and then insert/update in the actual destination table. The advantage in this pattern is that because the stg table usually does not have any primary keys / unique indexes etc and also generally all the datatypes are varchars, you don't encounter such issues as you are having.
After data is in stg table, just insert / update the destinatin table based on a mismatch query with the stg table.
Hope this helps.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy