Unpivot Transformation in SSIS

UNPIVOT Transformation in SSIS 6

The UNPIVOT Transformation in SSIS is used to convert the DE Normalized data into a more normalized version, which is similar to SQL UNPIVOT. The SSIS UNPIVOT Transformation acts precisely opposite to Pivot Transformation. Please refer to Pivot Transformation in SSIS article to understand, How to Convert Normalized data to DE Normalized data. Consider the below data as … Read more