Tag Archives: SSIS multicast and conditional split transformation

Multicast versus Conditional Split

Multicast and conditional split transformations are quite often used while developing an SSIS package. I have compiled some of the differences between the two transformations that might help understanding these transformations in a better way:

Multicast Conditional Split
Replicate source data to multiple destinations so that different logic can be applied to same source data Distribute the source data into multiple destinations based on conditions
Directs row to every output Directs row to single output
Does not contain any error output It has one error output
Do not require expressions Expressions are used for specifying conditions
Do not have default output It provides default outputĀ  so that if a row matches no expression it is directed to default output

If you have any constructive opinion, please write to me or post comments