.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Sandeep Singh
Melody Anderson
Eminent IT

Home >> Articles >> DataBase >> Post New Resource Bookmark and Share   

 Subscribe to Articles

Multi Cast Transformation in SSIS - SQL Server Integration Services (SSIS) - Part 53

Posted By:Karthikeyan Anbarasan       Posted Date: May 14, 2011    Points: 200    Category: DataBase    URL: http://www.dotnetspark.com  

In this article we are going to see on how to use the Multicast transformation in SQL Server Integration Services (SSIS) packaging.


In this article we are going to see how to use the Multicast transformation in SSIS packaging. Multicast transformation is used when a portion of the data needs to be transferred to some other flow which is something similar to Conditional task which does the same process. 

The difference between the Multicast and the conditional split transformations is that for Multicast directs each row of the source to every output, whereas in the conditional split it directs a row to a single output. So using the multicast we can create data of separate logic and try to have it secured across the flow. This transformation can have a single input with multiple outputs across to pass the data. Let's jump start to see this sample of how to set the properties of the control. 

You can also read my other articles on SSIS from Here


Follow steps 1 to 3 on my first article to open the BIDS project and select the right project to work on an integration services project. Once the project is created, we will see how to use the Multicast Transformation task. Once you open the project just drag and drop the Multi Cast transformation control and a source provider is shown in the image below: 

Now we need to configure the source data source as shown in the screen below: 

Once the source is configured now drag and drop 3 destinations providers as shown in the screen below.
  1. OLEDB provider task to update the table
  2. Flat file provider to update a file
  3. Excel provider to update to an excel file

Now let's configure each destination as shown in the image below. 

Here we created a new table where it will copy the complete dataset to the destination table using the multicast provider. 

Now let's configure the flat file provider as shown in the screen below: 

Now let us configure the excel destination provider as shown below: 

Now all the destination providers are configured. Now go back to the Multicast provider and double-click to see the configuration as shown below: 

Once everything is configured your screen should look like the screen below: 

Now the package is ready to execute. Press F5 and you will see that the screen looks like below which indicates that the execution is completed. 

To see the output in different destinations we can go ahead to the respective sections as shown below.

Output1: Table


Output 2: Flat file

Output 3: Excel destination file


So in this article we have seen how to use the Multicast transformation task and the key configurations used in order to use this task easily.

 Subscribe to Articles


Further Readings:


No response found. Be the first to respond this post

Post Comment

You must Sign In To post reply
Find More Articles on C#, ASP.Net, Vb.Net, SQL Server and more Here

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend