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.
Sources are the data flow components that make data from different types of data sources available to a data flow. Sources have one regular output and many have one error output.
The following table lists the sources that SQL Server 2005 Integration Services (SSIS) provides.
| Source | Description |
|---|---|
Consumes data from a .NET Framework data provider. |
|
Extracts data from an Excel file. |
|
Extracts data from a flat file. |
|
Consumes data from an OLE DB provider. |
|
Extracts raw data from a file. |
|
Uses script to extract, transform, or load data. |
|
Extracts data from an XML file. |
You can also write custom sources. For more information, see Developing a Custom Source Component.
See Also
Concepts
Integration Services Transformations
Integration Services Paths
Data Flow Elements
Other Resources
Integration Services Destinations