SSIS Aggregate Transformation

SSIS Aggregate Transformation

Integration Services uses transformations to manipulate data during an ETL dataflow. Transformations can be used in [[articles:SSIS Dataflow Task|Data Flow Tasks]], between data source and destination components, or other transformations.

In a BI environment, data consumers might not be interested of details which are irrelevant from their decision making point of view. In this case the ETL process must aggregate data - averages over time, summaries of margin per customer, maximum of order quantities per product, everything can be a requirement to roll up. Aggregation of data can be solved with the Aggregate transformation in SSIS.

The Aggregation transformation supports an input and multiple outputs, if different aggregations of the same source data would be needed at the same time. This enables the developer to write a more simple package, and the SSIS runtime engine have to read the source data only once. This transformation does not support an error output.


The Aggregate Transformation Editor with multiple outputs

This is a blocking transformation: since all input rows are needed to get the aggregations, the flow of data will stop until this transformation ends the calculation.

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 6 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: correcting links, adding example screenshot

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: correcting links, adding example screenshot

  • Zoltán Horváth edited Revision 2. Comment: correcting text alignment

  • Carsten Siemens edited Revision 6. Comment: Added tags: en-US, has comment

Page 1 of 1 (3 items)