SSIS: List of Transformations

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 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.

Leave a Comment
  • Please add 7 and 6 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • 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

Page 1 of 1 (7 items)
Wikis - Comment List
Sort by: Published Date | Most Recent | Most Useful
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
Comments
  • Zoltán Horváth edited Original. Comment: minor edit

  • Zoltán Horváth edited Revision 1. Comment: added a tag

  • Ed Price - MSFT edited Revision 4. Comment: Title casing & added tags

  • Zoltán Horváth edited Revision 5. Comment: Correcting typos, "Trasformation" -> "Transformation"

  • Zoltán Horváth edited Revision 6. Comment: linked Union All

  • Zoltán Horváth edited Revision 9. Comment: added link to Sort Transformation

  • Zoltán Horváth edited Revision 10. Comment: adding link to SSIS Row Count Transformation

  • Pretty nice task to complete with all references :)

  • Zoltán Horváth edited Revision 11. Comment: added link to Derived Column Transformation

  • Zoltán Horváth edited Revision 12. Comment: added link to SSIS Audit Transformation

  • Zoltán Horváth edited Revision 13. Comment: adding link to SSIS Lookup Transformation

  • Zoltán Horváth edited Revision 14. Comment: adding link to SSIS Row Sampling Transformation

  • 10 out of 29 transformations done. Checkpoint. If you would like a specific transformation to be written earlier than in my fairly random order, leave a comment here :)

  • 10 out of 29 transformations done. Checkpoint. If you would like to see a new one earlier than it would apper in my random order, just leave a comment here.

  • Merge Join is done 11/29.

Page 1 of 3 (32 items) 123