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 sources also have one error output.

There are three types of sources:

  • Sources that Setup installs when you install Integration Services.

  • Sources that are available to download from the Microsoft Web site.

  • Custom sources that you create if the existing sources do not meet your needs.

Built-In Sources

The following table lists the sources that SQL Server Integration Services provides.

Source

Description

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

Sources Available for Download

The following table lists additional sources that you can download from the Microsoft Web site.

Important

The sources listed in the following table work only with SQL Server 2008 Enterprise and SQL Server 2008 Developer.

Source

Description

Oracle Source

The Oracle source is the source component of the Microsoft Connector for Oracle by Attunity. The Microsoft Connector for Oracle by Attunity also includes a connection manager and a destination. For more information, see the download page, Microsoft Connectors for Oracle and Teradata by Attunity.

SAP BI Source

The SAP BI source is the source component of the Microsoft Connector for SAP BI. The Microsoft Connector for SAP BI also includes a connection manager and a destination. For more information, see the download page, Microsoft SQL Server 2008 Feature Pack.

Teradata Source

The Teradata source is the source component of the Microsoft Connector for Teradata by Attunity. The Microsoft Connector for Teradata by Attunity also includes a connection manager and a destination. For more information, see the download page, Microsoft Connectors for Oracle and Teradata by Attunity.

Custom Sources

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

External Resources

Technical article, Data Source Compatibility of SSIS Components, on social.technet.microsoft.com.

Integration Services icon (small) Stay Up to Date with Integration Services

For the latest downloads, articles, samples, and videos from Microsoft, as well as selected solutions from the community, visit the Integration Services page on MSDN or TechNet:

For automatic notification of these updates, subscribe to the RSS feeds available on the page.