modify records in one sql server which is differ from anothe server by DTS?

Hi all,

currently, I’ve been incolved in a data migration project. The objective is synchronize the sales invoice from one server to another server by DTS! And Now, I can use DTS to tranfer data between these two servers. But I just want to appending the new invoice without duplicate records. So I decide to mark the records which has been transfered and next time DTS will only choose the records which have not been marked.

But I still can not get it through after few days investigation :S

Any idear?

Best Regards,

Jascha