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


ADO NET Destination added in 2008

    Trains data mining models.

    Exposes the data in a data flow by using the ADO.NET DataReader interface.

    Loads and processes an SQL Server 2005 Analysis Services (SSAS) dimension.

    Writes data to an Excel Workbook.

    Write data to a flat file.

ODBC Destination added in 2012
    Loads data using an OLE DB provider.

    Loads and processes an Analysis Services partition.

    Writes raw data to a file

    Creates an ADO recordset.

    Uses script to extract, transform, or load data.

    Inserts rows into a SQL Server 2005 Compact Edition database.

    Bulk inserts data into a SQL Server 2005 table or view.