Extracting Data with Sources

After a Integration Services package contains a Data Flow task, you can start to create the package data flow. Integration Services includes three types of data flow components: sources, transformations, and destinations.

The following diagram shows a simple data flow with a source, two transformations, and a destination.

Data flow

You use the sources to extract data from files and databases. A data flow can include a single source or multiple sources. The outputs of sources can connect to transformations or destinations. For more information, see Integration Services Sources.

You can also write custom sources. For more information, see Developing a Custom Data Flow Component and Developing Specific Types of Data Flow Components.

After you add the source to the data flow designer and configure the source, you connect the output of the source to the input of another component in the data flow. For more information, see Connecting Components with Paths.

To add and configure a source when creating a package

  • Use either the the SQL Server Import and Export Wizard or Integration Services Connection Project Wizard.

    In addition to creating and configuring a source, these wizards also help you create and configure destinations, and the connection managers that are used by the sources and destinations. For more information, see Creating a Package by Running a Wizard.

To add a source to a data flow

To set the properties of a source

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.