tag:blogger.com,1999:blog-6357505892638015674.post3656406742174005498..comments2023-12-11T22:43:08.539-08:00Comments on Welcome to SQLServer MVP Blog: SSIS errors - Part 3Unknownnoreply@blogger.comBlogger2125tag:blogger.com,1999:blog-6357505892638015674.post-2009314298935155562009-09-30T05:27:15.608-07:002009-09-30T05:27:15.608-07:00The problem is due to the primary key... You need ...The problem is due to the primary key... You need to clear the identity value.... you need to do... <br /><br />dbcc reseed tablename identityvalue (It may 0 in your <br />case)<br /><br />Thanks and Regards,<br />Venkatesan Prabu .JVenkatesan Prabuhttps://www.blogger.com/profile/02685812384505488301noreply@blogger.comtag:blogger.com,1999:blog-6357505892638015674.post-47921889207082248592009-09-27T19:53:13.085-07:002009-09-27T19:53:13.085-07:00Hi,
I have truncated the table and trying to inse...Hi,<br /><br />I have truncated the table and trying to insert the new rows using SSIS batch job. Still i get the below error message<br />An OLE DB error has occurred. Error code: 0x80004005.<br /><br />An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "The statement has been terminated.".<br /><br />An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Violation of PRIMARY KEY constraint 'PK_ColumnName'. Cannot insert duplicate key in object 'dbo.TableName'."<br /><br />Please helpAnonymousnoreply@blogger.com