February 5, 2013 at 2:19 pm
HI
i have a qs: if i have a data flow task inside for loop container. and DFT contains five static connections of FLAt file as Source and Olde db as Destination .
and i want that on every iteration of For Loop , One out of Five Connections should be active depend upon variable mapping of For loop.
how could i achieve that?
thanks
February 6, 2013 at 12:32 am
iamsql1 (2/5/2013)
HIi have a qs: if i have a data flow task inside for loop container. and DFT contains five static connections of FLAt file as Source and Olde db as Destination .
and i want that on every iteration of For Loop , One out of Five Connections should be active depend upon variable mapping of For loop.
how could i achieve that?
thanks
You need five data flows in parallel.
Preceding the data flows, you need a single component - maybe just a sequence container.
Create a precedence constraint between the container and each of the data flows.
Double click each of the precedence constraints in turn. Change the evaluation operation to 'Expression and Constraint'. Set up the Expression such that it tests for the filename you are interested in for that data flow. In the multiple constraints section, select the 'Logical or' radio button (because only one of the constraints will execute at a time).
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply