http://www.sqlservercentral.com/blogs/katie-and-emil/2012/07/25/ssis-aggregate-transformation/ Printed 2014/07/22 10:12AM
SSIS aggregate transformation
2012/07/25In this SSIS 2012 tutorial we will show you how to use data flow Aggregate Transformation and we will use our example of Customer and Total Sales Amount which is an interesting example as often to get more insight into customer behaviour it is useful to slice and dice the data by Customer Total Spend (usually spend band not exact figure). Aggregate transformation allows us to do that but remember if you can use group by at source and your query is relatively simple than usually that is a better option. This tutorial is now part of our SSIS Tutorial and in the future will be part of exam guide 70-463 implementing a data warehouse using SQL Server 2012.