SQL Server Integration Services (SSIS) - Transformation Categorized in SSIS


This article is about various transformations and how they are categorized to be used across the package. This categorization is based on the usage of the transformation and the process of how it can be used across the package. The brief description of each of the transformations are available in my previous articles.
You can look into my series of articles on SSIS at the url - http://f5debug.net/all-articles/
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 the various transformations and the subcategories of each section.


Build smarter apps with Machine Learning, Bots, Cognitive Services - Start free.

Start Learning Now