What is multicast
multicast component creates the duplicate copies of the input.
When to multicast?
you want to do multiple sets of business rule or transformation of the same
data, then you can use multicast component.
Disadvantages of Multicast:
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.
Step 1: Drag & Drop the multicast component from Toolbox
and connect the input.
Step 2: Add OLEDB
destination component and Flat file destination component. Configure OLEDB
Destination component and flat file destination.
Step 3: Execute the package.
Now if you see above the image, the multicast component made
the duplicate copies of the source.