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 causes replication to fail

Author  Topic  midasman Starting Member 1 Post Posted - 2004-06-21 : 03:33:58 Hi everyone, i am using merge replication on ms sql server 2 sync to dbs. It works absolutely fine except when i run a DTS package that does a bulk insert and then a bulk delete. Basically i have a column on a table called 'delete' and i have a DTS package that does the following : 1. it sets the column 'delete' to 1 for all records. 2. it imports data from a tab delimited text file. 3. it then deletes all records that have 'delete' set to 1. While on the db that i run the dts package on it works fine, on the other db where the replciation is supposed to happen, all it does is deletes all the records. The replication monitor shows that they were 'X' updates and 'X' deletes but there are no records on the replica table. Any ideas? Thanks in advance