Floating FB popout byF5debug

SQL Server Integration Services (SSIS) – Part 54 – Transformation Categorized in SSIS


This is part 54 of the series of article on SSIS


In this article we are going to see on the different transformation on how they are categorized to use it across the package. This categorization is based on the usage of the transformation and the process on how it can be used across. The brief description of each of the transformations are available in my previous articles.

You can look into my series of article on SSIS at the url - http://f5debug.net/tutorial/ssis.aspx


We can partition the transformation into 7 types as shown below

  1. Row Transformations
  2. Rowset Transformations
  3. Split and Join Transformations
  4. Quality Transformations
  5. Mining Transformations
  6. Synchronous and Asynchronous Transformations
  7. Other Transformations

Now these transformations are further sub categorized as below

Row Transformations – Used to update column values and is applied to each row in the input dataset.

  • Character Map
  • Copy Column
  • Data Conversion
  • Derived Column
  • Script Component
  • OLE DB Command

Rowset Transformations – Used to create a new Rowset

  • Aggregate
  • Sort
  • Percentage Sampling
  • Row Sampling
  • Pivot
  • Unpivot

Split and Join Transformations – Used to distribute rows to different outputs, create copies of the transformation inputs

  • Conditional Split
  • Multicast
  • Merge
  • Merge Join
  • Union All
  • Lookup

Data Quality Transformations – Used to perform data quality operations

  • Fuzzy Lookup
  • Fuzzy Grouping

Data-Mining Transformations – Used to perform data-mining operations

  • Data-Mining Query
  • Term Extraction
  • Term Lookup

Synchronous and Asynchronous Transformations – Used to determine how rows are processed.

  • Synchronous transformations
  • Asynchronous transformations
  • Partially blocking transformations
  • Blocking transformations

Other Transformations – Some extra transformations

  • Export Column
  • Import Column
  • Audit
  • Row Count
  • Slowly Changing Dimension


So in this article we have seen on the different transformation and the subcategories of each section

About Author: Karthikeyan Anbarasan, Microsoft MVP (Most Valuable Professional) in ASP.NET/IIS Architecture. He is the Founder and Chief Editor of the www.f5debug.net website and has authored books on Windows Phone and Business Intelligence(SSIS). He is also a Passionate Speaker and a Blogger on Microsoft Technologies.

You can Join Me On: Facebook, Twitter, Google Plus, LinkedIn

Comments (1) -

6/11/2013 7:39:05 AM #


     you are providing SSiS material is very good,i read but some transfermation configurations are no clear and you are providing some Transfermation Configurations but it is not working some is working.Please rectify that one.

Add comment

  Country flag

  • Comment
  • Preview

Recent Posts

Random Posts

Most Viewed

URL Shortner

Create your own short urls!!!

Site Counter

free counters


This is a personal weblog. The opinions expressed here represent my own and not those of my employer. For accuracy and official reference refer to MSDN/ TechNet. I have documented my personal experience on this blog.

Protected by Copyscape Web Plagiarism Finder

Site Meter