Post reply

How to update table in DTS?

  • December 16, 2005 at 2:52 pm

    #166266

    Hi experts,

    I need to calculate and load summary sales data into table 1 in server A, then update on table 2 in Server B. 

    I am using DTS for this tasks.

    I have a [Execute SQL Task] to truncate table 1 in server A, then have 2 Microsoft OLEDB Provider for SQL Servers for loading the sales data.

    Then how to update tables?  which task transform I should use? 

  • December 17, 2005 at 11:40 am

    #610216

    Is the update on table2 on ServerB database based on data from table1 in ServerA ? If so, you can define a linked server on ServerB that points to ServerA and fire off the update using an openquery pass-through query or 4 part naming convention to get the data from table1 on ServerA. So, you will have another Execute SQL Task which will connect to ServerB and fire off the SQL query for doing the updates as needed.

  • December 18, 2005 at 5:05 pm

    #610242

    try DDQ - data driven query task.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply