SSIS – Lookup Component Problem

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 :

Table A

Column A1 (PK) Varchar(255) Column A2 (FK to Table B) Varchar(255)
1 11
2 12
3 11
4 14
5 11

You see that column A2 has several record with same values (11)

Table B

Column B1 (PK)

Varchar(255)

Column B2

Varchar(255)

11 A
12 B
13 C
14 D
15 E

Table C

Column C1 (PK)

Varchar(255)

Column C2 (FK to Table D)

Varchar(255)

1 0421095201
2 0414117102
3 0421095201
4 0414117102
5 0421095201

Here the data is same with Table A and also for column C2, it also has same values in its record.

Table D

Column D1 (PK)

Varchar(255)

Column D2

Varchar(255)

0421095201 F
0414117102 G

Continue reading “SSIS – Lookup Component Problem”