Hello,

There is a Table T, which exists in two databases on different servers S1 and S2.
I want to update all columns of T in S2 with the contents of T in S1, with a
"Join" on identical Primary Key Columns.

What kind of DTS-Task can I use, or have I to write a kind of ActiveX-Task for
a task like this?

Thank You

Joachim

For updating Table, you should use DataDriven Query Task.

In Queries Tab of DataDriven property window, you can write
INSERT/UPDATE/DELETE statement.

--
Regards
Bharat Jariwala



"Joachim Hofmann" wrote:

Hello Bharat,

Whilst this will work you need to be careful about the amount of rows you
are putting through the pipeline. The DDQ operates on each row 1*1. On
a sma;; rowset fine but larger ones will hurt.

SQL Server to SQL Server I may use OPENDATASOURCE() or a linkeds Server.


Allan