SSIS Tutorial Part 42- How to Use UnPivot Transformation in SSIS Package
Unpivot Transformation in SSIS Package is used to convert unnormalized datatset into more normalized dataset. By using UnPivot Transformation you will be converting the columns into single column.
The video explain why do we need to use UnPivot Transformation in SSIS Package.
The second part of the video consists of demo that will walk you through step by step how to read the data from flat file source and then Unpivot that by using UnPivot Transformation in SSIS Package.
At the end you will be able to see the data by using Data Viewer.
For Step by Step SSIS Video Tutorial by TechBrothersIT visit
http://www.techbrothersit.com/search/...