SSIS How to select user variable dynamically based on value of another user variable

Question

I have a ForEach loop for importing all available tables in source connection. I am using following user variables for this:

OracleTables of type System.Object for holding all tables from oracle DB
TableName for enumerating OracleTables of type String
set of Boolean variables (e.g. Enable_TABLENAME) one for each table to hold whether that table is to be imported or not.

Now, I want to configure the DataFlow task inside ForEach loop to run iff the value of corresponsing table variable if true. Basically, I want something like:

!@[User::Enable_@[User::TableName]] for Disable property of DataFlow task.

that is, I want to get the Boolean table variable for for current table held by TableName variable.

How can I achive this? Or else, is there any better way to do this? Any pointers would be really helpful.

@Siva I am following your answer to a post "stackoverflow.com/questions/6298806/…" with some modifications. — Agent007
– Agent007, Commented Feb 7, 2013 at 14:01

user1826905 · Accepted Answer · 2013-02-07 13:49:25Z

2

You can use ForEach Item Ennumerator (you can define your Items in the editor itself) or NodeList Ennumerator (and have your values in an XML file) or ADO.Net Ennumerator ( have your values coming from a SQL table instead).

answered Feb 7, 2013 at 13:49

user1826905

5683 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SSIS How to select user variable dynamically based on value of another user variable

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related