Unpivot data using Unpivot Transformation - SSIS 2012...

Unpivot data using Unpivot Transformation - SSIS 2012...

Unpivot is the process of transforming the column into row. its the reverse process of Pivot.

Step 1: let's take the data which we had created for Pivot from the database as shown below

Drag and drop the Dataflow task. Drop the OLEDB Source and map the Pivot Destination table data.

Drag and drop the Unpivot transformation and edit the data as shown below

Destination column must be specified as Expenses and the Pivot Key value Column Name at the bottom should be renamed instead of Pivot Key Value and Click ok.

Create the table called Monthly Destination as shown above and map the columns. Run the package to push the data from Pivot Destination to Monthly Destination

Regards

Daniel J

Dataware and Data Mining Architect...