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

Concepts

Integration Services Transformations
Integration Services Paths
Data Flow Elements

Other Resources

Integration Services Sources

Help and Information

Getting SQL Server 2005 Assistance