Integration Services Destinations

Community Content

In this section

Statistics Annotations (0)

Click here to expand

Collapse All

Other versions are also available for the following:

SQL Server 2005

SQL Server 2008 Books Online (October 2009)

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.

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 or TechNet:

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

Concepts

Integration Services Sources
Integration Services Transformations
Integration Services Paths
Data Flow Elements

Help and Information

Getting SQL Server 2008 Assistance