The sample package
CalculatedColumns.dtsx shows examples of the Aggregate, Derived Column, and Sort data flow transformations. The Aggregate transform allows you to easily perform aggregations of types GroupBy, Count, Count Distinct, Sum, Average, Minimum, or Maximum against your data flow by simply configuring the aggregate dialog box. The Data Flow work area for the Calculated Columns SSIS sample package is shown in Figure 8–28.
The “Add transformation” group contains some of the data flow transformation types that are most often used in BI projects: Copy Column, Import Column, and Union All. All of these transformations are self-explanatory.
The transformation group also contains the Merge and Merge Join transformations. ...