Chapter 4: Using Data Flow Transformations

 Download CD Content

Overview

After completing this chapter, you will be able to:

• Understand how data flow is constructed in a package.

• Understand the function of data flow transformations and when to use them.

• Create a new SSIS project and add a data flow task to it.

• Use Conditional Split, Derived Column, and Multicast transformations to aggregate, merge, distribute, and modify data.

• Configure how a component handles errors.

In Chapter 3, "Extracting and Loading Data," you learned how to create and configure connection managers, how to use data flow sources to extend the functionality of connection managers, and how to add a data flow task to extract data from a source and then load the results into a destination.

In this chapter, you'll take a closer look at how Microsoft SQL Server Integration Services (SSIS) can be used to transform data. As you work through the series of procedures in this chapter, you'll learn 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.