Reader Level:
ARTICLE

How to use SSIS Multicast Component

Posted by Muralidharan Deenathayalan Articles | SQL Server May 19, 2011
Here you will see how to use SSIS Multicast component.
  • 0
  • 0
  • 11258
Download Files:
 

What is multicast?

The multicast component creates the duplicate copies of the input. 

When to multicast?

When you want to do multiple sets of business rule or transformation of the same data, then you can use multicast component.

Disadvantages of Multicast:

The downside is that those outputs are synchronous outputs and therefore are on the exact same thread as the input dataset. Normally a Synchronous output is good as no memory has to swap buffers and it is exceptionally quick. A problem arises if we have on one or more of those outputs a blocking Asynchronous transform. When this happens processing of the other outputs is halted until the Asynchronous transform completes. This can really hurt performance.

Demo :

Step 1: Drag & Drop the multicast component from Toolbox and connect the input.

MC1.png

Step 2:  Add OLEDB destination component and Flat file destination component. Configure OLEDB Destination component and flat file destination.

mc2.png 


Step 3: Execute the package.

mc3.png

Now if you see above the image, the multicast component made the duplicate copies of the source.

COMMENT USING

Trending up