Multicast Transformation

The Multicast transformation distributes its input to one or more outputs. This transformation is similar to the Conditional Split transformation. Both transformations direct an input to multiple outputs. The difference between the two is that the Multicast transformation directs every row to every output, and the Conditional Split directs a row to a single output. For more information, see Conditional Split Transformation.

You configure the Multicast transformation by adding outputs.

Using the Multicast transformation, a package can create logical copies of data. This capability is useful when the package needs to apply multiple sets of transformations to the same data. For example, one copy of the data is aggregated and only the summary information is loaded into its destination, while another copy of the data is extended with lookup values and derived columns before it is loaded into its destination.

This transformation has one input and multiple outputs. It does not support an error output.

Configuring the Multicast Transformation

You can set properties through SSIS Designer or programmatically.

For more information about the properties that you can set in the Multicast Transformation Editor dialog box, see Multicast Transformation Editor.

For more information about the properties that you can set programmatically, click the following topic:

For more information about how to set properties, click one of the following topics:

See Also


Creating Package Data Flow
Integration Services Transformations

Help and Information

Getting SQL Server 2005 Assistance