This is a Fast Forward tutorial on Multicast Transformation in Microsoft SQL Server Integration Services.

Multicast Transformation

The Multicast transformation distributes its input to multiple outputs. It basically creates copies of an input dataset. This transformation has one input and multiple outputs. It does not support an error output.

Implementation

Here we want to create two copies of the source employee table data.

Control Flow

Here we have EMP table as OLEDB Source. Next we use a Multicast transform to create two copies of the employee dataset followed by two Flat File Destination as targets.

Data Flow

We can create as many copies of the input dataset we want. Below the properties of the transform viewed in Multicast Transformation Editor.

Multicast Transformation Editor

Multicast Transformation Editor

Use Multicast transformation to apply multiple sets of transformations logic to the same data set.

Multicast Transformation- Properties

For example, one copy of the source data can be used to load the dimension table, while another copy of the data is extended with lookup values and derived columns and aggregated before it is loaded into the fact table .


Have a question on this subject?

Ask questions to our expert community members and clear your doubts. Asking question or engaging in technical discussion is both easy and rewarding.

Are you on Twitter?

Start following us. This way we will always keep you updated with what's happening in Data Analytics community. We won't spam you. Promise.

  • SSIS- Merge Join Transform

    This is a Fast Forward tutorial on Merge Join Transformation in Microsoft SQL Server Integration Services.

  • SSIS- Lookup Transform

    This is a Fast Forward tutorial on Lookup Transformation in Microsoft SQL Server Integration Services.

  • SSIS- Conditional Split Transform

    This is a Fast Forward tutorial on Conditional Split Transformation in Microsoft SQL Server Integration Services.

  • SSIS- Derived Column Transform

    This is a Fast Forward tutorial on Derived Column Transformation in Microsoft SQL Server Integration Services.

  • SSIS- Union All Transform

    This is a Fast Forward tutorial on Union All Transformation in Microsoft SQL Server Integration Services.

  • SSIS- Aggregate Transform

    This is a Fast Forward tutorial on Aggregate Transformation in Microsoft SQL Server Integration Services.

  • SSIS- Multicast Transform

    This is a Fast Forward tutorial on Multicast Transformation in Microsoft SQL Server Integration Services.