Aggregate transformation

The Aggregate transformation is used to perform aggregate operations/functions on groups in a data set. The aggregate functions available are Count, Count Distinct, Sum, Average, Minimum and Maximum. The Aggregate transformation has one input and one or more outputs. It does not support an error output.

Aggregate Function	Details
AVERAGE	Give the Average value of the Columns or Attributes value
GROUP BY	Derived the data set into Group
SUM	Give the SUM value of the Columns or Attributes value
COUNT	Give the number of item in Groups
COUNT DISTINCT	Give the Unique NON NULL Item
MINIMUM	Give the Minimum Number in a Group
MAXIMUM	Give the Maximum Number in a Group

Step 1:

Click Windows button and go to SQL Server 2008 R2 and run as a administrator.

It shows  a bellow window.

Step 2:

Go to a views and create a new project ( Short cut of New Project is Ctrl + Shift + N).

Step 3:

Give a project name (e.g. IS) and click OK button and then shows a bellow window.

Step 4:

To drag and drop the Data Flow Task

Step 5: 

To edit the Data Flow Task then it open a Data Flow

Stem 6:

To dag and drop the OLE DB source and edit it.

Step 7:

To give a OLE DB connection and select the table from given data base and select which columns are required

Step 8:

To drag and drop the Aggregate transformation and edit it. Select which column you want. The operation is GROUP BY

Step 9:

To take a OLE DB destination and edit it, to take a which table you want.

Step 10:

Select which columns you want and map it.

Step 11:

To add a Data Viewer.

Data Viewer can be used between two transformations to see the data. When we executes our package Data Viewer pop up window shows data so we can see What is changed from Input to Output.

Step 12:

To execute the task.