Updating SQL Tables from another DB

[SWTpaul]

Our main box is an IBM iSeries which is used for all our business applications. I have been able to use DTS to copy the tables I want and push them into MS SQL Server.

The problem is, if I run the same DTS it will insert the same records into the tables, creating multiple records (that I don't want), rather than updating the data.

How can I get the DTS to update the records in the tables, rather than add/insert the same records everytime it is run?

Thanks!

 

[SimeonJ]

Create a stored procedure that updates the data where needed.