Applies To: SQL Server 2016
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.
You can set properties through SSIS Designer or programmatically.
For information about the properties that you can set in the Multicast Transformation Editor dialog box, see Multicast Transformation Editor.
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.