Introduction: 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 look into my series of articles on SSIS at the url - http://f5debug.net/all-articles/
C# Corner. All contents are copyright of their authors.