Microsoft® SQL Server™ 2005 Integration Services Step by Step
by Hitachi Consulting Paul Turley Joe Kaspizak, Scott Cameron, Satoshi Iizuka, and Pablo Guzman
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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access