SSIS: List of Transformations
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 [[articles:SSIS Dataflow Task|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 [[articles:SQL Server Integration Services (SSIS)|Integration Services]] 2012:
- [[SSIS Aggregate Transformation]]
- [[SSIS Audit Transformation]]
- SSIS Cache Transform Transformation
- [[SSIS Character Map Transformation]]
- [[SSIS Conditional Split Transformation]]
- SSIS Copy Column Transformation
- SSIS Data Conversion Transformation
- SSIS Data Mining Query Transformation
- [[SSIS Derived Column Transformation]]
- SSIS DQS Cleansing Transformation
- SSIS Export Column Transformation
- SSIS Fuzzy Grouping Transformation
- SSIS Fuzzy Lookup Transformation
- SSIS Import Column Transformation
- [[SSIS Lookup Transformation]]
- [[SSIS Merge Transformation]]
- [[SSIS Merge Join Transformation]]
- [[SSIS Multicast Transformation]]
- [[SSIS OLE DB Command Transformation]]
- SSIS Percentage Sampling Transformation
- [[SSIS Pivot Transformation]]
- [[SSIS Row Count Transformation]]
- [[SSIS Row Sampling Transformation]]
- [[SSIS Script Component Transformation]]
- SSIS Slowly Changing Dimension Transformation
- [[SSIS Sort Transformation]]
- SSIS Term Extraction Transformation
- SSIS Term Lookup Transformation
- [[articles:SSIS Union All Transformation|SSIS Union All Transformation]]
- [[articles:SSIS Unpivot Transformation|SSIS Unpivot Transformation]]
For more information about SSIS transformations, see the Integration Services Transformations topic in Books Online.