for each loop container nested SSIS

Question

Can you create a foreach loop container within a foreach loop container?

As the handling of variables for this situation?

Object type have two variables, which take the value of two fields come from a database and query SQL Server 2012 on an Oracle, to return me two camps. The join is with two fields, so I require two for each loop container or otherwise as would be?

I believe I understand your first question but the rest of your question doesn't quite make sense to me. Could you click the Edit button an try to explain differently what your problem is? — billinkc
– billinkc, Commented May 28, 2015 at 21:05

user3662215 · Accepted Answer · 2015-05-28 22:37:56Z

1

Yes, you can create a ForEach loop nested within another ForEach loop with both applying separate object variables. Also, each object variable can be defined by one or multiple parameters (Variable Mappings) originating from field value results of SQL queries. If I understand correctly, you wish to filter the object of the nested ForEach based on the enumeration of the parent ForEach loop container? That can be done with SQL or via Expressions.

answered May 28, 2015 at 22:37

user3662215

5264 silver badges13 bronze badges

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

Collectives™ on Stack Overflow

for each loop container nested SSIS

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related