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 2001-01-11 2 2 bbb 2009-02-23 3 3 ccc