Chapter 4. Using Data Flow Transformations
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, 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 ...
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.
