Multicast Transformation

Applies to: SQL Server SSIS Integration Runtime in Azure Data Factory

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.

Configuration of the Multicast Transformation

You can set properties through SSIS Designer or programmatically.

For information about the properties that you can set programmatically, see Common Properties.

For information about how to set properties of this component, see Set the Properties of a Data Flow Component.

Multicast Transformation Editor

Use the Multicast Transformation Editor dialog box to view and set the properties for each transformation output.


Select an output on the left to view its properties in the table on the right.

All output properties listed are read-only except Name and Description.

See Also

Data Flow
Integration Services Transformations