Update rows from DTS

Hello,

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 creatign 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 woudl be ideal.

Any ideas or suggestions?

Thanks,
Jeff

you could create a DTS that run every 5-10 minutes

just create two connections and a query that will update the rows that you want or simply delete the destination and transfert the table alltogether