Chapter 5: Managing Control Flow


image from book Download CD Content

Overview

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, "Using Data Flow Transformations," 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 tasks to organize and structure your package, and define an order of execution by defining precedence and conditions between tasks or groups of tasks. You'll also learn how to use Fuzzy Lookup to perform data cleaning and a Foreach Loop container for repetition of a specific task. Specifically, you'll learn how to group, organize, and arrange tasks into a control flow. You will also learn how to use a Foreach Loop container to extend the functionality of a regular container.




Microsoft SQL Server 2005 Integration Services Step by Step
MicrosoftВ® SQL Server(TM) 2005 Integration Services Step by Step
ISBN: 0735624054
EAN: 2147483647
Year: 2007
Pages: 152

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net