Hi, I have a scenario where there are duplicate records in source itself. In that case SCD (SSIS 2005) inserts all the records in target without updating. Here is the sample scenario: My Source table structure is like ID (Primary Key) , MGR_Id , MGR_NAME , MGR_DOJ Values are : 1 1 XXX .. more »