How to use Pivot Transformation in SSIS Package

Pivot Transformation is used to convert Row Data into Columns. Pivot transformations makes normalized data less normalized.

In this video you will learn
Why do we need to use Pivot Transformation
Demo: How to use Pivot Transformation and details about Pivot Transformation Window setup

Pivot Key : Provide the column name which value you want to convert to columns
Set Key : Provide the column which values will be grouped as a row value
Pivot Value: Provide the column which has values

Note : You can ignore to provide the values and run your package in debug and then copy from output window or progress window and reopen and provide in Generate pivot output Column from values text box. As I know the values for my column those are month names , I have provided by myself or I could have run the package with Ignore and copy them later.

How to use Pivot Transformation in SSIS Package - SQL Server Integration Services(SSIS) Tutorial


  1. It is really frustrating when you do not share your source data, now i have to draw up it from scratch and it takes allot of time