How to use Unpivot Transformation in SSIS

The Unpivot Transformation is a way to accomplish this business requirement. In this example, you’ll be shown how to use the Unpivot Transformation to create rows in the Data Flow from columns and shown how it is the opposite of the Pivot Transformation.

Package design

Source File

Unpivot settings

Execute the package. You’ll see that the Valid Customer output goes to the customer table, and the NULL data condition is just thrown out.

Cheers!
Uma