SQL Server Integration Services transformations are the components in the data flow of a package that aggregate, merge, distribute, and modify data. Transformations can also perform lookup operations and generate sample datasets. This section describes the transformations that Integration Services includes and explains how they work.
Business Intelligence Transformations
The following transformations perform business intelligence operations such as cleaning data, mining text, and running data mining prediction queries.
Row Transformations
The following transformations update column values and create new columns. The transformation is applied to each row in the transformation input.
Rowset Transformations
The following transformations create new rowsets. The rowset can include aggregate and sorted values, sample rowsets, or pivoted and unpivoted rowsets.
Split and Join Transformations
The following transformations distribute rows to different outputs, create copies of the transformation inputs, join multiple inputs into one output, and perform lookup operations.
Auditing Transformations
Integration Services includes the following transformations to add audit information and count rows.
Transformation | Description |
|---|
Audit Transformation | The transformation that makes information about the environment available to the data flow in a package. |
Row Count Transformation | The transformation that counts rows as they move through it and stores the final count in a variable. |
Custom Transformations
See Also