How to use Multicast Transformation in SSIS

Description:-

In this post we will discuss another transformation control which is Multicast transformation.

Multicast is a way which help us to provide multiple copy of same source data for different transformation. Or in other words we can say multicast transformation create multiple pipelines for the same data.

Let’s understand this by an example. Suppose, we have customer based on customer groups so we need to bifurcate the customer based on customer group like which customer is “Foreign” or else who is “Domestic” customer.

Step 1:- Add a package and drag drop data flow task and configure source database. I am taking Adventurework2012 database and using Sql command for source data below is simple snap of data

Step 2:- Once the data is configured. Drag drop Multicast control as shown in below figure and give output of source object to Multicast and try to configure it.

Step 3:- Now, when we have configured Multicast we can get multiple output from Multicast control. Suppose, there are multiple customer group so based on the customer group we have to configure the derived column. Here we have “Foreign” and “Domestic” customer group so we will drag and drop two derived columns from the tools.

I configured the 2 different output in same way and adding the respective flat files. As shown in below figure you will see we added 2 files.

Step 4:- Now once everything is configured run the package by pressing F5 or hitting run button you will get following screen. So, if you see Multicast providing similar row count to different output.

We, can use this Multicast where we need multiple copy of same source data.

Author : Umesh Patel

Related Posts