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