iamsql1 (2/5/2013)
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
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).
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.