Integration Services uses transformations to manipulate data during an ETL dataflow. Transformations can be used in [[articles:SSIS Dataflow
Task|Data Flow Tasks]], between data source and destination components, or other transformations.
There are many cases (for example, in reporting), when some elements of a dataset has to be transposed. The Pivot transformation can help in this during the load process of a data warehouse.
For example, if the source dataset looks like this (three columns):
So, the Pivot transformation can be used as an opposite transformation of the Unpivot transformation, which is helpful when a more normalized result set is needed.
For more detailed information on this transformation, please refer to this MSDN article.
For the complete list of SSIS transformations, check this Wiki article.
This article is also available in the following languages:
This page should be updated to SQL 2012 ASAP.
Zoltán Horváth edited Revision 1. Comment: adding Other Languages, tagging