Row Transformation

The following transformations update column values and create new columns. The transformation is applied to each row in the transformation input.

Character Map Transformation

The Character Map transformation applies string functions, such as conversion from lowercase to uppercase, to character data. This transformation operates only on column data with a string data type.
You configure the Character Map transformation in the following ways:
·         Specify the columns to convert.
·         Specify the operations to apply to each column.

Copy Column Transformation
The transformation that adds copies of input columns to the transformation output. The Copy Column transformation creates new columns by copying input columns and adding the new columns to the transformation output.

Data Conversion Transformation
The transformation that converts the data type of a column to a different data type.

Derived Column Transformation
The Derived Column transformation creates new column values by applying expressions to transformation input columns

Export Column Transformation
The Export Column transformation reads data in a data flow and inserts the data into a file. For example, if the data flow contains product information, such as a picture of each product, you could use the Export Column transformation to save the images to files.

Import Column Transformation
The Import Column transformation reads data from files and adds the data to columns in a data flow. Using this transformation, a package can add text and images stored in separate files to a data flow

Script Component
The Script component hosts script and enables a package to include and run custom script code

OLE DB Command Transformation
The OLE DB Command transformation runs an SQL statement for each row in a data flow. For example, you can run an SQL statement that inserts, updates, or deletes rows in a database table.