Extracting Data
After a SQL Server 2005 Integration Services (SSIS) 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.
.gif "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.
To add a source to a data flow
To set the properties of a source
How to: Set the Properties of a Data Flow Component Using a Component Editorx
How to: Set the Properties of a Data Flow Component Using the Advanced Editor
How to: Set the Properties of a Data Flow Component in the Properties Window
See Also
Tasks
Adding a Data Flow Task
Transforming Data
Connecting Components
Loading Data
Handling Errors in Data
Concepts
Data Flow Task
Data Flow Elements
Creating Package Data Flow