Hands-On Microsoft SQL Server™ 2005 Integration Services

Summary

The workflow in Integration Services consists of containers. Two containers, For Loop and Foreach Loop, provide the repeating logic, which was available to procedural languages previously. With the advent of SSIS, you have at your disposal the For Loop Container to perform repeating logic to the tasks contained within it, the Foreach Loop Container to perform the repeating logic for each item in a collection, and the Sequence Container to group tasks and containers, allowing you to have multiple control flows by having multiple Sequence Containers under one package.

In the beginning of the chapter, when you learned about the Package Container, you read that within the Integration Services architecture design, a package sits at the top ...