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

DataReader Source

Consumes data from a .NET Framework data provider.

Excel Source

Extracts data from an Excel file.

Flat File Source

Extracts data from a flat file.

OLE DB Source

Consumes data from an OLE DB provider.

Raw File Source

Extracts raw data from a file.

Script Component

Uses script to extract, transform, or load data.

XML Source

Extracts data from an XML file.

You can also write custom sources. For more information, see Developing a Custom Source Component.

See Also


Integration Services Transformations
Integration Services Paths
Data Flow Elements

Other Resources

Integration Services Destinations

Help and Information

Getting SQL Server 2005 Assistance