Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AngoloBanficio
Starting Member
5 Posts |
 Posted - 2014-07-29 : 22:37:18
|
| 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 |
|
|
|
|
|
Loop through excelsheet rows and lookup another sh