Floating FB popout byF5debug

SQL Server Integration Services (SSIS) – Part 32 – Aggregate (Group By) Transformations Control in SSIS


This is part 32 of the series of article on SSIS. In this article we are going to see on how to use an Aggregate (Group by) data flow transformation control in SSIS packaging.


In this article we are going to see on how to use an Aggregate (Group by) data flow transformation control in SSIS packaging. With this function operation we can get a list of grouping necessary to get result in desired format. Let’s jump into to the example on how to use this control in real time.

You can look into my series of article on SSIS at the url - http://f5debug.net/tutorial/ssis.aspx



Follow steps 1 to 3 on my first article to open the BIDS project and select the right project to work on integration services project. Once the project is created, we will see on how to use an aggregate control for grouping the columns

Here we will see on the Group By operation in the aggregate control. I have added an OLEDB connection which fetches the data from the database upon which we are going to do Grouping manipulations and then pass it to a file destination as shown in the below screen


Here last 2 controls shows a red mark inside the control indicating that the control is not configured. We step forward and configure the same. Now double click on the Aggregate function will open a pop-up windows as shown in the below screen


Here we are selecting the columns on which we need a Grouping of data as shown in the screen. And after selecting the number of columns for the group then clicks on the OK button to get configured. Now configure the Flat File Destination as shown in the below screen.


Once everything is configured your screen will look as shown in the below screen


Now Hit F5 will run the application and show the output as shown in the below screen


Here the numbers of rows are indicated at the bottom of the each control as shown in the above screen. And finally the results (Grouping of the columns based on product) are loaded to flat file destination which looks like below



So in this article we have seen on how to do a grouping of a number of columns using an Aggregate function transformation in data flow tab.

About Author: Karthikeyan Anbarasan, Microsoft MVP (Most Valuable Professional) in ASP.NET/IIS Architecture. He is the Founder and Chief Editor of the www.f5debug.net website and has authored books on Windows Phone and Business Intelligence(SSIS). He is also a Passionate Speaker and a Blogger on Microsoft Technologies.

You can Join Me On: Facebook, Twitter, Google Plus, LinkedIn

Add comment

  Country flag

  • Comment
  • Preview

Recent Posts

Random Posts

Most Viewed

URL Shortner

Create your own short urls!!!

Site Counter

free counters


This is a personal weblog. The opinions expressed here represent my own and not those of my employer. For accuracy and official reference refer to MSDN/ TechNet. I have documented my personal experience on this blog.

Protected by Copyscape Web Plagiarism Finder

Site Meter