June 2007
Beginner to intermediate
480 pages
12h 30m
English
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 ...
Read now
Unlock full access