Resources For IT Professionals
Post an article
Wikis - Page Details
  • First published by (1Microsoft Partner, Microsoft Community Contributo)
  • When: 13 Jan 2012 5:05 AM
  • Last revision by
  • When: 29 Aug 2013 11:56 PM
  • Revisions: 42
  • Comments: 32
Options
RSSSubscribe to Article (RSS)
Can You Improve This Article?
Positively! Click Sign In to add the tip, solution, correction or comment that will help other users.

Report inappropriate content using these instructions.
Wiki  >  TechNet Articles  >  SSIS: List of Transformations

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.

, , , , , , , , , [Edit tags]
Leave a Comment
  • Please add 8 and 2 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • 28 May 2013 8:37 AM

    Carsten Siemens edited Revision 39. Comment: Added tags: en-US, has comment

  • 2 Jul 2012 4:45 AM

    Zoltán Horváth edited Revision 36. Comment: adding reference to SSIS Unpivot Transformation

  • 20 Mar 2012 9:09 AM

    Zoltán Horváth edited Revision 35. Comment: Added SSIS DQS Cleansing Transformation to the list

  • 3 Feb 2012 9:18 AM

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

  • 3 Feb 2012 8:32 AM

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

  • 14 Jan 2012 12:01 AM

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

  • 13 Jan 2012 5:30 AM

    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
  • Posted by
    on 13 Feb 2012 7:52 AM

    Zoltán Horváth edited Revision 26. Comment: It's a link collection to transformations. New features and their details of upcoming versions would deserve a new link collection instead.

  • Posted by
    on 13 Feb 2012 3:05 PM

    Zoltán Horváth edited Revision 27. Comment: re-adding links after reverting

  • Posted by
    on 13 Feb 2012 3:11 PM

    Zoltán Horváth edited Revision 28. Comment: link to SSIS Percentage Sampling Transformation still did not work

  • Posted by
    on 13 Feb 2012 3:14 PM

    Zoltán Horváth edited Revision 29. Comment: trying with URL for Percentage Sampling

  • Posted by
    on 13 Feb 2012 3:17 PM

    Strange, linking SSIS Percentage Sampling Transformation with double brackets did not work, even with the "articles:" tag - only URL link is working...

  • Posted by
    on 13 Feb 2012 3:26 PM

    Zoltán Horváth edited Revision 30. Comment: aligning text

  • Posted by
    on 15 Feb 2012 9:25 AM

    Zoltán Horváth edited Revision 31. Comment: added link to SSIS Script Component transformation

  • Posted by
    on 15 Feb 2012 9:29 AM

    Zoltán Horváth edited Revision 32. Comment: added link to SSIS Character Map Transformation

  • Posted by
    on 18 Feb 2012 4:19 PM

    Zoltan, I featured your work in this blog post here: blogs.technet.com/.../top-10-wiki-ninjas-zolt-225-n-horv-225-th-takes-on-sql-server-integration-services.aspx

    Great job! Thanks!

  • Posted by
    on 18 Feb 2012 4:46 PM

    Thanks, Ed! :)

  • Posted by
    on 20 Mar 2012 9:07 AM

    Zoltán Horváth edited Revision 34. Comment: Updated to recent version (SQL 2012)

  • Posted by
    on 20 Mar 2012 9:09 AM

    Zoltán Horváth edited Revision 35. Comment: Added SSIS DQS Cleansing Transformation to the list

  • Posted by
    on 2 Jul 2012 4:45 AM

    Zoltán Horváth edited Revision 36. Comment: adding reference to SSIS Unpivot Transformation

  • Posted by
    on 4 Jul 2012 4:08 AM

    11 out of 29 transformations now as Unpivot was added.

  • Posted by
    on 4 Jul 2012 4:09 AM

    Sorry, it's 17 :)

Page 2 of 3 (32 items) 123