HI,What are the scenrios will be getting primary key violation issues in ssis packages?Please find the error message below: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 10.0" Hresult: 0x80004005 Description: "The statement has been terminated.". An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Violation of PRIMARY KEY constraint .Please tell me the issue with the above message?

Issue is that you are trying to insert an already inserted value in the Primary key column.Nitesh Rai- Please mark the post as answered if it answers your question

please configure the error output ... and check the data. this is data issue.Let us TRY this | Dont forget to mark the post(s) that answered your question http://quest4gen.blogspot.com/

KIR222,That error message indicates that you are trying to send data to the destination, where the values in the primary key columns already exist.You will have to check the destination table to find out what the primary key constraint columns are, and then work accordingly in your package.See this link if you need to update rows that exist already, otherwise insert them: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1211340&SiteID=1Phil Brammer | http://www.ssistalk.com | Twitter: http://twitter.com/PhilBrammer

Hi, We have checked the data no issue with the data.actually the record is inserting in the table but after that it is giving the error as primary key violation and package is failing. We are not able to figure it out y its throwng error after inserting.Please help us.

Is the table (the destination table) is empty before the package starts?Nitesh Rai- Please mark the post as answered if it answers your question

for testing , truncate the destination table (in DEV env) and then load the data.. Let us TRY this | Dont forget to mark the post(s) that answered your question http://quest4gen.blogspot.com/

i suggest that you turn on ssis logging (if you haven't already done so), then post the log messages.Duane Douglas, MCAD, MCITP | http://www.ssisbi.com | Please mark the post(s) that answered your question.

Could there be a foreign key constraint somewhere?Hope this helps !! Sudeep| My Blog

Did you ever find solution to this problem? I have exactly the same issue. Any response would be greatly appreciated