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)
Now, with those 4 data source, I use lookup component to get a reference data with flow like this :
But when I use Table C and look up its foreign key to Table D. It was failed with error message “Row yielded no match during lookup”. Do you have any idea about it?
I just don’t have any idea, for some kind of data it didn’t work even with the same data type.