While Loading Refering Other Table Values.

1, abcd, qrs, 1000
2, efgh, tuv, 1000
3, ijkl, wxy, 1000
4, mnop, mno, 1000



lets assume the excel data seems to be above one.


Iam populating to the T1 table (below one) from the Excel source (above data)

Create Table T1(
ID int,
BaID int, -- Foreign Key, BA(ID)
BaBrID int, -- Foreign Key BABR(ID)
Amt int)



When iam populating values for BaID and BaBrid have to refer the respective tables BA(ID) and BaBR(ID) see the below tables.

Create Table BA(
ID int,
BAName varchar(25))



Create Table BABR(
ID int,
BABRName varchar(25))


Could anyonly please help me like which transformation have to use for this and how to use, just give me some tips.


Regards,
Newly to SSIS