The List of Transformation are provided by SSIS in 2008

The List of Transformation are provided by SSIS. 
Total 29 Transformations are available in SSIS 2008

• Aggregate
• Audit
• Cache Transformation
• Character Map
• Conditional Split
• Copy Column
• Data Conversion
• Data Mining Query
• Derived Column
• Exporting Column
• Fuzzy Grouping
• Fuzzy Look Up
• Import Column
• Look up
• Merge
• Merge Join
• Multicast
• OLEDB Command
• Percentage Sampling
• Row Count
• Row Sampling
• Script Component
• Slowly Changing Dimension
• Sort
• Term Extraction
• Term Look up
• Union All
• UnPivot

Sort:

This is used to Sort the given input based on one or more column in scheduling or descending

orders.

     

Data Conversion:

This is used to convert data column one data type column to another data type column in the data flow.

     

Copy Column:

This is used to perform complex calculation on existing column on existing column and produce a new column. It can be applied to any data type column.

Conditional Split:

This is used to split the input based on one or more conditions.

Union All:  

Used to merge many inputs and produce combined out put. input needs to be sorted.

       

Merge: 

Used to merge two inputs and produce combined output.

Two inputs meta data should be same.

Two inputs must be sorted inputs.

Out put structure will be same as input

NOTE: MERGE and UNION-ALL produces output with duplicate rows by default.

  

Merge Join:

Used to join two  inputs and produce and produce one output.

Two inputs may have dissimilar  structure

Two inputs must be sorted inputs.

Out put structure is combined structure of  both inputs.

It requires one common column.

Inputs should be sorted order.

  

Look up:

It is used to compare given inputs rows with any external data structure look up table.

Look up will be perform equivi  join comparision .

Look up comparision is data type sensitive and case sensitive.

Look up will produce matched rows on out put and unmatched rows on error output.

General look up is used to check for given input row in the destination table for existence and

avoid duplicate data loading.  

     

Data Aggregate:  

The process of converting data and rows into summarized rows is called Data Aggregation.

      

Aggregate:

This is used to group the input based on one or more column and perform aggregation on

required column.

     

Audit: 

This enable access to environment and package data in data flow.

   

Character map:      

This can apply string transformations to columns either as new column or in place  changes.

This transformations includes Lower case,Upper case, Half width and Full width etc..

Derived Column:

 It enables inline transformation using SSIS expressions to transform the data.

Fuzzy Grouping:

This enables data cleansing activities during the transformation by identifying similarities between data rows.

Fuzzy Lookup:

This enables data cleansing activities includes standardize data, correcting data and providing

missing values. By using this transformation is , would be follow a standard look up transformation for record that do not find  a match.

Pivot: 

This transformation takes a normalized data  and transform it into a denormalized version 

by  pivoting the input data  on a column value.

Unpivot:

This transformation performs exactly perform inverse of the pivot transformation.

  

Multicast: 

This transformation  can distribute the copies of the same data flow to multiple destinations.