Right now, I’m doing task on SQL Server Integration Service 2005 (SSIS), and I have a problem with case like this.
Let’s say I have 4 data sources (tables), along with its data :
|Column A1 (PK) Varchar(255)||Column A2 (FK to Table B) Varchar(255)|
You see that column A2 has several record with same values (11)
|Column B1 (PK)
|Column C1 (PK)
|Column C2 (FK to Table D)
Here the data is same with Table A and also for column C2, it also has same values in its record.
|Column D1 (PK)