Transform Data with Transformations
Applies to:
SQL Server
SSIS Integration Runtime in Azure Data Factory
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.
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
See Also
Data Flow Task
Data Flow
Connect Components with Paths
Error Handling in Data
Data Flow
Povratne informacije
https://aka.ms/ContentUserFeedback.
Stiže uskoro: Tokom 2024. godine postepeno ćemo ukidati probleme sa uslugom GitHub kao mehanizam povratnih informacija za sadržaj i zameniti ga novim sistemom povratnih informacija. Dodatne informacije potražite u članku:Prosledite i prikažite povratne informacije za