Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Loop through excelsheet rows and lookup another sheet

Status
Not open for further replies.
kccoolrocks

kccoolrocks

Programmer
May 14, 2008
6
0
0
AU
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
 
Sort by date Sort by votes
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?
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

arunaramana
  • Locked
  • Question
what are the items in a collection that referred in foreach item type enumerator within foreach loop
Replies
1
Views
70
Igelchen
Igelchen
arunaramana
  • Locked
  • Question
use case to 'Name and Extension', 'Full Qualified' and 'Name Only' options in foreach file enumerato
Replies
0
Views
60
arunaramana
arunaramana
BTrees
  • Locked
  • Question
SSIS Lookup Component Error -"Row yielded no match during lookup"
Replies
0
Views
48
BTrees
BTrees
Durbslaw
  • Locked
  • Question
Sub report won't render lookup data fields
Replies
0
Views
30
Durbslaw
Durbslaw
denisetic01
  • Locked
  • Question
Hello, I am new to SSIS and I woul
Replies
0
Views
36
denisetic01
denisetic01

Part and Inventory Search

Sponsor

Back
Top