How to use SSIS Multicast Component

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.

Up Next
    Ebook Download
    View all
    Learn
    View all