Aggregate(SSIS)

The Aggregate Transform allows you to aggregate data from the Data Flow to apply certain TSQL
functions that are done in a GROUP BY statement like Average, Minimum, Maximum, and Count.
The most important option is the Operation drop - down box.
For this option, you can select the following:

• Group By: Breaks the dataset into groups by the column you specify .
• Average: Averages the selected column ’ s numeric data .
• Count: Counts the records in a group .
• Count Distinct: Counts the distinct non - NULL values in a group .
• Minimum: Returns the minimum numeric value in the group .
• Maximum: Returns the maximum numeric value in the group .
• Sum: Returns sum of the selected column ’ s numeric data in the group .