Monday, March 03, 2014

MultiCast Transformation in SSIS

The Multicast Transform, as the name implies, can send a single data input to multiple output paths easily. You may want to use this transformation to send a path to multiple destinations sliced in different ways. To configure the transform, simply connect the transform to your input, and then drag the output path from the Multicast Transform onto your next destination or transform. After you connect the Multicast Transform to your first destination or transform, you can keep connecting it to other transforms or destinations. There is nothing to configure in the Multicast Transformation Editor other than the names of the outputs.

The Multicast Transformation is similar to the Split Transform in that both transformations send data to multiple outputs. The Multicast will send all the rows from the path, whereas the Split will conditionally send part of the data to the path.

No comments:

Post a Comment