When it comes to data processing, Integration Services reads data from various sources, and writes them to their destinations, but usually some transformation of the data is needed in the meantime (according to the requirements, of course). SSIS can transform the data using its own transformation components. These can be used when placed in a Data Flow Task, connected with the source and destination components, or other transformation components. So, here is the complete list of transformation components built into Integration Services 2012:
For more information about SSIS transformations, see the Integration Services Transformations topic in Books Online.
Carsten Siemens edited Revision 39. Comment: Added tags: en-US, has comment
Zoltán Horváth edited Revision 36. Comment: adding reference to SSIS Unpivot Transformation
Zoltán Horváth edited Revision 35. Comment: Added SSIS DQS Cleansing Transformation to the list
Zoltán Horváth edited Revision 6. Comment: linked Union All
Zoltán Horváth edited Revision 5. Comment: Correcting typos, "Trasformation" -> "Transformation"
Ed Price - MSFT edited Revision 4. Comment: Title casing & added tags
Zoltán Horváth edited Revision 1. Comment: added a tag
Zoltán Horváth edited Revision 37. Comment: adding link to SSIS Pivot Transformation