SQL Server Performance

DTS package

Discussion in 'General DBA Questions' started by bfarr23, Jan 9, 2004.

  1. bfarr23 New Member

    how do i update one db.table based on another db.table from within a DTS package?

    is this possible?
    do i need a linked server?
  2. gaurav_bindlish New Member

    I think you'll have to write a custom query for the same.

    No you don't need a linked server if both the databases under consideration are on the same server.

    Gaurav
    Moderator
    Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard
  3. satya Moderator

    If its a simple data updation then DTS is best bet, or even you can specify the query paramets to do so and as suggested by Gaurav LS is not a factor and its an overhead too.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page