AggregateTransformOperation Enumeration

The AggregateTransformOperation enumeration provides options for which aggregation operation will be used in a SQL Server Integration Services Aggregate transformation.

Enumeration Values

Name	Summary
GroupBy	Specifies that the column values will be grouped into sets with like values.
Count	Specifies that the count of non-null items in the group will be returned.
CountDistinct	Specifies that the count of distinct, non-null items in the group will be returned.
Sum	Specifies that the sum of values in a numeric column will be returned.
Average	Specifies that the average of values in a numeric column will be returned.
Minimum	Specifies that the minumum of values in a numeric, date, or time column will be returned.
Maximum	Specifies that the maximum of values in a numeric, date, or time column will be returned.
CountAll	Specifies that the count of items (including nulls) in the group will be returned.