|
Home > Archive > MS SQL Server DTS > January 2006 > Which Task to use for Updating T1 with T2
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Which Task to use for Updating T1 with T2
|
|
| Joachim Hofmann 2006-01-19, 7:23 am |
| 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
| |
| bharat jariwala 2006-01-19, 7:23 am |
| 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,
>
> 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
>
| |
| Allan Mitchell 2006-01-21, 7:23 am |
| 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
[color=darkred]
> For updating Table, you should use DataDriven Query Task.
>
> In Queries Tab of DataDriven property window, you can write
> INSERT/UPDATE/DELETE statement.
>
> "Joachim Hofmann" wrote:
>
|
|
|
|
|