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.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Trying to export a table from MDB to a SDB help!

Author  Topic 

jarablue
Starting Member

9 Posts

Posted - 2010-06-23 : 03:09:14
Hey guys. I am running DTS to try and export a table from the MDB to a SDB. When I export the table, I can see it copying out the rows...then it gets to the end of the rows in the table and shows this...




I really need to export this table as it is holding up replication. Anyone have a clue how I can get DTS to fully export the table witout error? Thanks!

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-06-23 : 03:16:08
Your primary key is blocking duplicate data. You'll need to decide whether or not you want duplicate data or not. If you want duplicate data, then drop the PK. If you don't want duplicate data, then you'll need to figure out why you've got duplicate data. Perhaps you just need to truncate the destination table first.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

jarablue
Starting Member

9 Posts

Posted - 2010-06-23 : 04:03:34
I would love to truncate the table but it is saying since it's published for replication, I can't truncate the table. How can I remove the publishing?
Go to Top of Page
   

- Advertisement -