Look at Slowly Changing Dimensions.

I scanned the thread but didn't see it mentioned. The SCD wizard will walk you through the steps required.

What is the source

What is the primary key to identify an existing record

What changes do you want to capture

Do you want to keep historical versions of the records

What fields should cause an error if they change (e.g. supplier ID)

SCD will not however pick up physically deleted records as it only compares records from source with records in target so if it does not exist in source it will not get compared. If the record is updated with a flag to identify it as deleted rather than being actually deleted then it will be OK. SCD can be slow because it will compare all columns in all records. You can speed it up if there is a field you can use to define a Delta (e.g. LastModifiedDateTime > today - 5 days)