This article explains the SSIS pivot transformation and how it differs from the unpivot transformation.