SQL Server Performance

Update rows from DTS

Discussion in 'SQL Server DTS-Related Questions' started by jmottle, Apr 2, 2004.

  1. jmottle New Member


    I'm trying to create a DTS package that allows me to update a new database for a new site with the rows from the old site's database. I know how to get the data to the new database, transformed how I want, and I know hot to append rows, but I have not been able to figure out how to do updates to rows. I want to create a package that inserts new rows and updates any changes made to old rows.

    Becuase the old site will remain live while I am creating the new one, I want to ensure that all of the data is transfered daily so I can make any necesary adjustments.

    Ideally if there was a way to somehow link data from the old database to the new database so that the two were kept syncronous on a real time basis that would be ideal.

    Any ideas or suggestions?

  2. derrickleggett New Member

    There are two ways to do this in DTS that I know of.

    1. Replace the tables that have been updated each day.
    2. Write a stored procedure to do an update for you, and run that from DTS.

    Neither are particularly attractive or easy.

    Derrick Leggett

  3. satya Moderator

Share This Page