CODEWITHSUNDEEP
ssis
Daniel Ramirez
Daniel Ramirez

Reputation: 17

for each loop container nested SSIS

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?

Upvotes: 1

Views: 4004

Answers (1)

user3662215
user3662215

Reputation: 526

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.

Upvotes: 1

Related Questions