Transform Data with Transformations


Integration Services 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 Connect Components with Paths.

To add a transformation to a data flow

To connect a transformation to a data flow

To set the properties of a transformation

Data Flow Task
Data Flow
Connect Components with Paths
Error Handling in Data
Data Flow