SSIS Multicast Transformation

SSIS Multicast Transformation

Integration Services uses transformations to manipulate data during an ETL dataflow. Transformations can be used in Data Flow Tasks, between data source and destination components, or other transformations.

Sometimes the data flow must be processed in a detailed and an aggregated way, or different types of aggregations might be needed at the same time. This is when Multicast can be useful.

The Multicast is a basic data flow transformation which splits the data into multiple paths, sending all incoming rows to each of the outputs. It does not support error outputs since it does not apply any update on the data.
Basically, the Multicast transformation can be used to multiplicate all rows.

This is an example about a Multicast transformation, sending all rows to 3 different paths:

A bit funny, but this transformation has an editor also. Spot all properties you can set here:

You have an overview of all outputs here, on the left pane.

The Multicast is an asynchronous (also known as partially blocking) transformation, which means that the the output records does not necessarily have a 1:1 relation with an input row, and the output of the transformation is copied into new buffers and new threads may be introduced into the data flow.

For more detailed information on this transformation, please refer to this MSDN article.
For the complete list of SSIS transformations, check this Wiki article.

Leave a Comment
  • Please add 1 and 3 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • Zoltán Horváth edited Revision 1. Comment: minor correction, adding a simple case of use and some funny screenshots

Page 1 of 1 (1 items)
Wikis - Comment List
Sort by: Published Date | Most Recent | Most Useful
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
Comments
  • Zoltán Horváth edited Revision 1. Comment: minor correction, adding a simple case of use and some funny screenshots

  • Hi Zoltán, the Conditional Split and Multicast don't create new buffers. Wouldn't that make them non-blocking?

Page 1 of 1 (2 items)