Chapter 5. Managing Control Flow

After completing this chapter, you will be able to:

  • Understand control flow management.

  • Group and organize tasks in a control flow, using different types of containers.

  • Use Fuzzy Lookup and the Foreach Loop container to extend the functionality of cleaning data and repeating control flow in a package.

  • Design the flow of a package, applying precedence constraints between components of a package.

In Chapter 4, you learned how to develop packages that use a data flow task and a variety of data flow transformations to extract data from a data source, perform transformations, and load the transformed data into a destination table or file. In this chapter, you’ll learn how to design a control flow of tasks, group data flow ...

Get Microsoft® SQL Server™ 2005 Integration Services Step by Step now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.