Update rows from DTS | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

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 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? Thanks,
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
You can take advantage of merge replication in this case if you require only append updated rows, refer ot thishttp://www.databasejournal.com/features/mssql/article.php/1438231 &http://www.mssqlcity.com/Articles/Replic/ValidMR/ValidMR.htm for Merge replication and also books online. HTH Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.