• Article

Integration Services Destinations

Destinations are the data flow components that load the data in a data flow into different types of data sources or create an in-memory dataset. Destinations have one input and one error output.

There are three types of destinations:

  • Destinations that Setup installs when you install Integration Services.

  • Destinations that are available to download from the Microsoft Web site.

  • Custom destinations that you create if the existing destinations do not meet your needs.

Built-In Destinations

The following table lists the destinations that SQL Server Integration Services provides.

Destination

Description

ADO NET Destination

Loads data into a variety of ADO.NET-compliant databases that use a database table or view.

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 Analysis Services dimension.

Excel Destination

Writes data to an Excel Workbook.

Flat File Destination

Write data to a flat file.

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 Compact database.

SQL Server Destination

Bulk inserts data into a SQL Server table or view.

Destinations Available for Download

The following table lists additional destinations that you can download from the Microsoft Web site.

Important

The destinations listed in the following table work only with SQL Server 2008 Enterprise and SQL Server 2008 Developer.

Source

Description

Oracle Destination

The Oracle destination is the destination component of the Microsoft Connector for Oracle by Attunity. The Microsoft Connector for Oracle by Attunity also includes a connection manager and a source. For more information, see the download page, Microsoft Connectors for Oracle and Teradata by Attunity.

SAP BI Destination

The SAP BI destination is the destination component of the Microsoft Connector for SAP BI. The Microsoft Connector for SAP BI also includes a connection manager and a source. For more information, see the download page, Microsoft SQL Server 2008 Feature Pack.

Teradata Destination

The Teradata destination is the destination component of the Microsoft Connector for Teradata by Attunity. The Microsoft Connector for Teradata by Attunity also includes a connection manager and a source. For more information, see the download page, Microsoft Connectors for Oracle and Teradata by Attunity.

Custom Destinations

You can also write custom destination components that can connect to and store data in any custom data source. For more information, see Developing a Custom Destination Component.

External Resources

Technical article, Optimized Bulk Loading of Data into Oracle, on msdn.microsoft.com.

Integration Services icon (small) Stay Up to Date with Integration Services

For the latest downloads, articles, samples, and videos from Microsoft, as well as selected solutions from the community, visit the Integration Services page on MSDN:

For automatic notification of these updates, subscribe to the RSS feeds available on the page.