Integration Services Sources
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