Transforming Data

SQL Server 2005 Integration Services (SSIS) includes three types of data flow components: sources, transformations, and destinations.

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

Data flow

Integration Services transformations provide the following functionality:

  • Splitting, copying, and merging rowsets and performing lookup operations.
  • Updating column values and creating new columns by applying transformations such as changing lowercase to uppercase.
  • Performing business intelligence operations such as cleaning data, mining text, or running data mining prediction queries.
  • Creating new rowsets that consist of aggregate or sorted values, sample data, or pivoted and unpivoted data.
  • Performing tasks such as exporting and importing data, providing audit information, and working with slowly changing dimensions.

For more information, see Integration Services Transformations.

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

After you add the transformation to the data flow designer, but before you configure the transformation, you connect the transformation to the data flow by connecting the output of another transformation or source in the data flow to the input of this transformation. The connector between two data flow components is called a path. For more information about connecting components and working with paths, see Connecting Components.

To add a transformation to a data flow

To connect a transformation to a data flow

To set the properties of a transformation

See Also


Adding a Data Flow Task
Extracting Data
Loading Data
Connecting Components
Handling Errors in Data


Data Flow Task
Data Flow Elements
Creating Package Data Flow

Help and Information

Getting SQL Server 2005 Assistance