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 |
No comments:
Post a Comment