Floating FB popout byF5debug

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

 

This is part 53 of the series of article on SSIS

Introduction:

In this article we are going to see on how to use the Multicast transformation in SSIS packaging. Multi cast 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 do the same process.

The difference between the Multicast and the conditional split transformations are multicast direct each row of the source to the every output where as 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.

[more]

Let’s jump start to see this sample on how to set the properties of the control. You can look into my series of article on SSIS at the url - http://f5debug.net/tutorial/ssis.aspx

 

Steps:

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

clip_image001

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

clip_image002

Once the source is configured now drag and drop 3 destinations providers as shown in the below screen

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

clip_image003

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

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

clip_image004

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

clip_image005

Now let us configure the excel destination provider as shown below

clip_image006

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

clip_image007

Once everything is configured your screen should look like below screen

clip_image008

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

clip_image009

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

Output1: Table

clip_image009[1]

Output 2: Flat file

clip_image010

Output 3: Excel destination file

clip_image011

Conclusion:

So in this article we have seen on how to use the Multi Cast transformation task and the key configurations used in order to use this task handy.

About Author: Karthikeyan Anbarasan, Microsoft MVP (Most Valuable Professional) in ASP.NET/IIS Architecture. He is the Founder and Chief Editor of the www.f5debug.net website and has authored books on Windows Phone and Business Intelligence(SSIS). He is also a Passionate Speaker and a Blogger on Microsoft Technologies.

You can Join Me On: Facebook, Twitter, Google Plus, LinkedIn

Add comment

  Country flag

biuquote
  • Comment
  • Preview
Loading

Recent Posts

Random Posts

Most Viewed

URL Shortner

Create your own short urls!!!

Site Counter

free counters

Disclaimer

This is a personal weblog. The opinions expressed here represent my own and not those of my employer. For accuracy and official reference refer to MSDN/ TechNet. I have documented my personal experience on this blog.

Protected by Copyscape Web Plagiarism Finder

Site Meter