Knight's Microsoft SQL Server 2012 Integration Services 24-Hour Trainer

Section 6

Containers

• Lesson 41: Using Sequence Containers to Organize a Package
• Lesson 42: Using For Loop Containers to Repeat Control Flow Tasks
• Lesson 43: Using the Foreach Loop Container to Loop Through a Collection of Objects

Chapter 41

Using Sequence Containers to Organize a Package

Sequence Containers provide a simple and easy method for organizing the flow of a package and can help you divide a package into more manageable pieces. When you first begin exploring the Sequence Container, you may think organization is the only benefit it provides. However, to the creative developer, this container’s uses go far beyond simple organization. If you know how to use it, it can also grant you the following capabilities:

• Grouping tasks so that you can disable a part of the package that’s temporarily not needed
• Narrowing the scope of a variable to just the container
• Collapsing and expanding the container to hide the tasks within
• Managing the properties of multiple tasks in one step by setting the properties of the container
• Using one method to ensure that multiple tasks execute successfully before the next task executes
• Creating a transaction across a series of data-related tasks, but not on the entire package
• Creating event handlers on a single container so that you can send an e-mail if anything inside one container fails, and perhaps even page yourself if anything else fails (event handlers are discussed in more detail in Lesson 48)

To add a Sequence Container to a package, ...