Logo DWBI.org Login / Sign Up
Sign Up
Have Login?
Login
New Account?
Recovery
Go to Login
SSIS

SSIS- Multicast Transform

Updated on Sep 30, 2020

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
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
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
Multicast Transformation Editor
Multicast Transformation Editor

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

Multicast Transformation- Properties
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.