August 26, 2008 at 8:46 am
[Transfer SQL Server Objects Task] Error: Execution failed with the following error: "ERROR : errorCode=-1071636471 description=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: "Violation of PRIMARY KEY constraint 'PK_tbl_combined_teamRec_lookup'. Cannot insert duplicate key in object 'tbl_combined_teamRec_lookup'.". helpFile=dtsmsg.rll helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}".
That is the error message I got. Any ideas? When I used sql2000 without problems.
October 1, 2008 at 8:52 am
if U are copying data set replace option to true and make sure to copy the schema too;)
April 16, 2015 at 3:08 pm
I'm also having the same problem. Can someone assist with a solution to this problem
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply