Transforming 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 Connecting 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

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.