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