Start

The Start component marks the beginning of an execution flow.

The Start component has no input ports. It has a single output port that accepts only one connection to either a Task Group or Decision component.

Since each SQL Transformation project needs a single Start component, it is automatically added to each project.

The Start component allows you to create user-defined variables, for which you are required to provide a name, type, and an optional initial value. Double-click the Start component in the Design window or select the component and click the Variables icon in the Properties window, to access the Variable Editor. All variables are defined at the project level and can be used by other components in the same project.

Start Component Compatibility with Other SQL Transformation Components

Component

Input

Output

Task Group

No

Yes

Decision

No

Yes

Finish No No
Error No No