Changes of the Data Transformations in SSIS from SQL 2005 to SQL Server 2014

Business Intelligence Transformations
-        Perform business intelligence operations such as cleaning data, mining text, and running data mining prediction queries.

Slowly Changing Dimension Transformation
Fuzzy Grouping Transformation
Fuzzy Lookup Transformation
Term Extraction Transformation
Term Lookup Transformation
Data Mining Query Transformation

DQS Cleansing Transformation added in 2012
Row Transformations
-        Update column values and create new columns. The transformation is applied to each row in the transformation input.

Character Map Transformation
Copy Column Transformation
Data Conversion Transformation
Derived Column Transformation
Export Column Transformation
Import Column Transformation
Script Component
OLE DB Command Transformation

Rowset Transformations
-        Create new rowsets. The rowset can include aggregate and sorted values, sample rowsets, or pivoted and unpivoted rowsets.

Aggregate Transformation
Sort Transformation
Percentage Sampling Transformation
Row Sampling Transformation
Pivot Transformation
Unpivot Transformation

Split and Join Transformations
-       Distribute rows to different outputs, create copies of the transformation inputs, join multiple inputs into one output, and perform lookup operations.

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

Cache Transformation added in 2008

Balanced Data Distributor Transformation added in 2014
Auditing Transformations
-        Add audit information and count rows.

Audit Transformation
Row Count Transformation

Custom Transformations
-        Write custom transformations.