Our company has three servers. One server is situated at the head office, and the other two servers are located 150 miles away. These servers communicate only through a dial-up connection. I want to use Data Transformation Services (DTS) to update data in one of the remote servers while the main server is in replication mode. Under these conditions, can I use DTS to enter approximately 10,000 records, one by one, using customized software?
...