The Definitive Guide to Data Quality
If you are using TIS, it is easy to synchronize data from a source table to a destination table with CDC feature.
I imagine you'd have to do this as:
1. Read the source
3. First replication to tMSSQLOutput component with Update or Insert option
4. Second replication to tMap as lookup with main flow from destination table with inner join rejects going to second tMSSQLOutput component with Delete option
If you want a combined action, you could put a feature request into the BugTracker.