execute concatenated lookups in excel sheet using SSIS RRS feed

  • Question

  • 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.




    Wednesday, July 30, 2014 3:33 AM

All replies

  • Not possible directly inside SSIS. You need to get value calculated in excel itself and then use it for data extraction in SSIS. Alternatively you can add source columns in excel and include excel formulas inside ssis derived column task to calculate them inside SSIS while doing data transfer

    Please Mark This As Answer if it helps to solve the issue Visakh ----------------------------

    Wednesday, July 30, 2014 4:29 AM
  • Import both columns in SSIS and concatenate using the derived column. which is easy and nice way to acheive this.


    Zaim Raza.

    Wednesday, July 30, 2014 4:49 AM
  • I used script task and loop through the sourc,e which is moer efficient way to do this. thanks all for your ideas.

    Tuesday, August 12, 2014 7:49 AM