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.
Related Tasks
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.
Options
Outputs
Select an output on the left to view its properties in the table on the right.
Properties
All output properties listed are read-only except Name and Description.
See Also
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for