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.

The following table lists the destinations that SQL Server 2005 Integration Services (SSIS) provides.

Destination Description

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.

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.

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.

See Also


Integration Services Transformations
Integration Services Paths
Data Flow Elements

Other Resources

Integration Services Sources

Help and Information

Getting SQL Server 2005 Assistance