Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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