SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Loop through excelsheet rows and lookup another sh
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

5 Posts

Posted - 07/29/2014 :  22:37:18  Show Profile  Reply with Quote

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.

  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000