DTS Data import doesnt get replicated

[srajeevkumar]

Hi,

I am trying to setup a merge replication between our servers in UK and HK which is working quite well on various tests. But in one of the tables in Uk when I import data from an Excel file using a DTS package it works well and imports the data into the concerned table.

Please note that this table along with the other tables merge replicated with the HK server. But somehow none of the records added via the DTS import gets replicated to HK.

What setting am I missing . What do I need to enable for the replication to happen.

Any help is very welcome.


Rgds

 

[srajeevkumar]

Well I found the solution. DTS uses some form of bulk copy and hence the bulk insert dont get replicated. Now I import everything into a temporary table and then copy from the temporary table into the actual table using the insert into syntax. In this case all the newly added records got replicated as well.
That has resolved the problem.
Thanks.