Hands-On Microsoft SQL Server™ 2005 Integration Services

Split and Join Transformations

These transformations can create multiple copies of input data, split input data into one or more outputs, merge multiple inputs, or add columns to the pipeline by looking up exact matches in the reference table. After reading through the descriptions for these split and join transformations, you will complete your first Hands-On exercise for this chapter that will cover some of the Row transformations also.

Conditional Split Transformation

When you want to apply transformation operations based on a particular type of data set, you need to split data to match the specific criteria. To split data into multiple data sets using conditions, you will use Conditional Split transformation. This transformation allows you ...