SSIS – Looping Over Object Variables with as ADO Enumeration in Foreach Loop Container
Foreach Loop container in SSIS allows you to loop over the values of the object variable and store the necessary information as a result set to variables to be used anywhere in SSIS for different purposes. 1- Create a object variable and fill it with information: See: SSIS – Storing Dataflow results to Object Variable with