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

	2005	2008/2008R2	2012/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.