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 »