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

Figure 1-9 . Editing the result set
The Execute SQL task is now complete. Next, you need to iterate through each
server to retrieve the metadata you plan to monitor. This process will be encapsulated
within a Foreach Loop container, which will shred the list of SQL Server instances
stored in the SQLServerList variable.
Add a Foreach Loop container to the Control Flow and rename it Foreach SQL
Server Instance . Connect it to the Execute SQL task with a Success Precedence con-
straint—in other words, drag the green arrow from the Execute SQL task to the
Foreach Loop container, as seen in Figure 1-10 .
Figure 1-10 . Connecting the Execute SQL task to the Foreach Loop container