Task

[mayu03]

I have 2 connection (conn1 and conn2) to the different sources.
I need to do the following logic:
1. Select data from conn1 based on pk
2.Compare the data to the data in conn2 based on pl
3.If data exists in conn2 update conn1 based on pk
Please help me with the task I should use in order to do this.

 

[JoeSack]

Hi,

DTS may not be necessary for what you are looking for. You could set up a linked server to Server 2 on Server 1, then create a stored procedure that checks data on the second server and inserts or updates data accordingly.

You can then schedule the execution of the stored procedure as a SQL Server job (or call it from DTS if you prefer). The key here is, a Transform Data task wouldn't necessarily be the best solution for data synchronization.

PS: Merge replication may also be worth taking a look at too.

Best Regards,
Joseph Sack,

http://www.JoeSack.com

Author of "SQL Server 2000 Fast Answers for DBAs and Developers".