Metadata Collection - SQL Server Integration Services Design Patterns - page 15

Double-click the Foreach Loop container to edit its properties. Click the Collection
page, and then select Foreach ADO Enumerator in the Enumerator field. Under ADO
Object Source Variable, select User::SQLServerList; leave Enumeration Mode set to
Rows in the First Table. Your Collection properties should match those in Figure 1-11 .
Figure 1-11 . The Foreach Loop Editor
On the Variable Mappings page, map the SQLServerInstance variable to In-
dex 0, as demonstrated in Figure 1-12 .