January 22, 2008 at 11:12 am
I am using a DTS package to copy a table from one database to another. The tables have the exact same fields in them (Project_Key, Project_Num, Project_Title, etc.) I am wanting to take the data in the "Import" table and append it to the data in the "New" table (so, I want to keep the data that is in the New table and just add to it the new Projects). The Project_key is normally the primary key and has an identity of 1. For the purpose of copying these new projects, I took off the primary key and identity in the "New" table hoping this would help it copy over with no problems. I want to bring the Project_Key over from the "import" table into the "new" table. But, I keep getting this error every time I run the DTS:
"The task reported failure on execution.
The statement has been terminated.
Cannot insert duplicate key row in object 'tblname' with unique index 'IX_tblname'."
I have double-checked that there are no duplicate Project_Keys. Any other ideas of why this is happening?
January 22, 2008 at 11:40 am
what field(s) is ix_tablename on? need to make sure no dupes (including source and existing rows in destination) in that field (or fields) including nulls.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply