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
Enjoy!
ssisblog 