Loop through excelsheet rows and lookup another sheet

[kccoolrocks]

Hi,

Have an excel sheet with 20 Columns. One Column has a Concatenated two vlookups that referes to another sheet.

Eg: Sheet one InsuranceType column includes - CONCATENATE((VLOOKUP(Q2,'Sheet2'!AX:AY,2,FALSE))," / ",(VLOOKUP(R2,'Sheet2'!AX:AY,2,FALSE))). Q2 and R2 get two different offers and result seperates by "/".

How to process this concatenated lookup using SSIS by looping each row in sheet 1.


Thanks,
Kosala

 

[jjefferson]

The formula should be evaluated for you as the package executes. You should see the concatenated values load into the mapped column in your SQL Server table. Is this not happening when you test your import?