Data Flow->> Pivot

This component and the pivot of SQL Server are basically the same thing. However, I observed that the pivot of SSIS only supports SUM of this aggregation type, and does not find which selection can set the aggregation type, while the T-SQL syntax pivot supports a variety of aggregation types, including max,min,avg,sum.

There are three main options:

1) Pivot Key: Column values that act as columns in the result set

2) Set Key: This is an optional group by when understanding aggregation

3) Pivot Value: The aggregated column

After setting these three options in fact generate Columns now is still gray, need to modify the above input box value to trigger it to become clickable state.

Here's a blog post about this component: http://www.cnblogs.com/biwork/p/4197075.html

Data Flow->> Pivot