Choose one static source inside for loop

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Integration Services » Choose one static source inside for loop

Choose one static source inside for loop

Rate Topic

Display Mode

Topic Options

Author

Message

iamsql1

Posted Tuesday, February 05, 2013 2:19 PM

Grasshopper

Group: General Forum Members
Last Login: Monday, April 29, 2013 7:59 AM
Points: 24, Visits: 86

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

Post #1416101

Phil Parkin

Posted Wednesday, February 06, 2013 12:32 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 2:25 AM
Points: 4,235, Visits: 9,472

iamsql1 (2/5/2013)

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

____________________________________________________________________________________________

Help us to help you. For better, quicker and more focused answers to your questions, consider following the advice in this link:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

If you are asking for help and your post does not contain a question, you should expect responses which do not contain any answers. Put a question mark in there somewhere - it's not rocket science.

Post #1416282

« Prev Topic | Next Topic »

Permissions