Most people are familiar with Pivoting within Excel- where  row values are converted to columns.  For those familiar with Microsoft Access the same process is known as a Crosstab query.  The pivot transformation in SSIS is a bit different from the process in Excel and Access as there isn’t any  aggregation  process associated the transformation. So if you want to aggregate data in a pivot in SSIS you also need to first add a Aggregate transformation. Unfortunately the pivot transformation is one of the most difficult SSIS transformations to use  as it requires multiple settings to be configured.  I have no idea why the SQL team have designed it this way – as the process used to create a Crosstab in Access is so easy. So to help out with configuring a pivot transformation I have produced the following videos that take you through the process.