Hi,

Can any one please let me know how i can join a table in one server
with a table in another server using DTS. The result from the SQL that
contains this join condition will be transformed to another table in
one of the servers.

Regards,
Sharan

[quoted text, click to view]

Hi Sharan,

You can do this in SQL by using Linked Servers, however unless you
have high bandwidth between the servers this can be fairly time
consuming. It might be better to pump the data that you need to join
into a temp table on the destination server and perform the join
there.

In SSIS it is possible to do a Merge Join of data between 2 different
source servers. This is an in-memory join which can be very efficient
if implemented correctly (and on a suitably spec'd server).

Good Luck!
J