Unpivot Transformation in SSIS

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. Please refer to the Pivot Transformation article to understand How to Convert Normalized data to DE Normalized data. Consider the below data as our SSIS … Read more