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  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  DTS export not replace existing data

Author  Topic  plvasco Starting Member 2 Posts Posted - 2010-11-12 : 12:15:39 I have created a development DB and did a export from production to development. That worked perfect, but I noticed that when I do a DTS export and choose copy object and data between SQL Server DB the replace existing data option doesn't seem to work. The job finishes successfully in seconds and the data is not updated. Where should I start