Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jarablue
Starting Member
9 Posts |
 Posted - 2011-04-14 : 00:06:49
|
| I am trying to DTS export a table and when I do I get a "violation of primary key contraint PK 'table name' cannot insert duplicate key row in object 'table name'I am dts exporting this table from the MDB to a SDB. How can I fix this?Thank you! :) |
|
|
ajur
Starting Member
2 Posts |
Posted - 2011-04-14 : 13:28:35
|
| you need to check for existance of data in the database before inserting the same to the table.Ajur |
 |
|
|
Jahanzaib
Posting Yak Master
115 Posts |
Posted - 2011-04-15 : 14:38:03
|
| Same data is inserting at the time of export in the primary key column,PRIMARY KEY column cannot insert the same data in a columnExample :If table have a Primary key column C1 and C1 has an Id 1 already exist then you export the data which one have also Id 1 then this error will occurRegards,Syed Jahanzaib Bin HassanMCTS,MCITP,OCA,OCP,OCE,SCJP,IBMCDBA |
|
|
|
jarablue
Starting Member
9 Posts |
Posted - 2011-04-22 : 04:22:32
|
| Yeah the odd thing is I tried deleting and truncating the table...still doesn't let me export. The table is empty....? |
|
|
|
|
|
|
Trying to DTS Export a table but getting pk constr