Cast

Use to convert one data type to another data type.

Expression

Use to define an expression that can be used to compute results.

in

Container for the input parameters for the transform. This container can be empty and not connected to any object on the workspace.

Loop

Use to generate target sequences based on a source sequence.

out

Container for the transformation outputs. This container cannot be empty.

Query

Use to join, filter, and group data.

Resource

Use to add a table, view, XML file, SQL script, or other valid TDV resource to the Transformation editor.

Switch

Use to conditionally map a target from one of a set of sources.

You can have any number of inputs, and one output. Each input has an expression associated with it. The first expression that evaluates to true causes its associated input to be passed through as the output.

Union

Use to combine the result sets of two or more items in your transform. All the source inputs must have the same data type. Unions can be used to remove duplicate rows between the items that are input.