Transform Data with Transformations
Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).
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.
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.
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.