Multicast Transformation

Multicast transformation is useful when we need to make many copies of same data or we need to move the same data to different destination. It has one input and many outputs. The Multicast transformation distributes its input to one or more outputs. Suppose I have one excel as source and want to migrate data into difference database like (Dev, QA, and Prod) for such type of scenario we need to use Multicast Transformation.

In Control flow Item take data flow task.

Double click on the data flow task.

In data Flow take excel as data flow source. Make the connection.

Now I am taking data conversion transformation.

Convert the columns  as per destination data type.

Click ok.

Now I am taking multi cast transformation.

After that I have three Oledb destinations.

Map the source and destination columns.

After completing the mapping build the package and execute the package.

Package Executed successfully.

Now see the result in database.

SSISTest DB

BEE DB result

EMP DB