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

2005	2008/2008R2	2012/2014
	ADO NET Destination added in 2008
Data Mining Model Training Destination     Trains data mining models.
DataReader Destination     Exposes the data in a data flow by using the ADO.NET DataReader interface.
Dimension Processing Destination     Loads and processes an SQL Server 2005 Analysis Services (SSAS) dimension.
Excel Destination     Writes data to an Excel Workbook.
Flat File Destination     Write data to a flat file.
		ODBC Destination added in 2012
OLE DB Destination     Loads data using an OLE DB provider.
Partition Processing Destination     Loads and processes an Analysis Services partition.
Raw File Destination     Writes raw data to a file
Recordset Destination     Creates an ADO recordset.
Script Component     Uses script to extract, transform, or load data.
SQL Server Compact Edition Destination     Inserts rows into a SQL Server 2005 Compact Edition database.
SQL Server Destination     Bulk inserts data into a SQL Server 2005 table or view.