We are Katie & Emil and together we have decided to learn more & more on how to build data warehouses using Microsoft products. The best option to learn is to teach so we write tutorials and share it with others.
In 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.