SSIS Task -- Aggregate and Audit

                                        Aggregate

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

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

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

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

Audit 

Here you can find the packageName and the VersionID at the right end for all the records which satisfied the condition.

Value	Variable Name	Description
0	ExecutionInstanceGUID	GUID that identifies the instance running
1	PackageID	Unique identifier od the package running
2	PackageName	Name of the package
3	VersionID	Version ID of the package
4	ExecutionStartTime	Time when the package is started
5	MachineName	Computer Name on which package running
6	UserName	User Name under which package running
7	TaskName	Name of the task which is running
8	TaskId	Unique identifier of the task running