Update changed rows

[dpk136]

I have a Progress 9.1D DB that i am getting data from in SQL Server 2000 DTS. The DTS will run on a schedule and i would really like it if it just updated the rows that were different between the 2 databases. It would only need to update if it did not find the row in SQL Server that it has in Progress and update the SQL Server data if the record changed in Progress. Is this possible or am i looking at just having to delete all the data in a table and append.

David Kuhn
------------------

http://www.davidpkuhn.com

 

[Glowworm27]

I would import the data into a temp table and then evaluate the data from there. Just selecting the data that is different, and updating the appropriate rows.

George Oakes
Check out this awsome .Net Resource!

http://www.learnvisualstudio.net

 

[dpk136]

I thought DTS could handle this?

David Kuhn
------------------

http://www.davidpkuhn.com