Column expression
The column expression identifies the columns to include in the SELECT statement.
You can specify the following parts:
- Job parameter. A dialog box appears offering you a choice of available job parameters. This allows you to specify the value to be used in the query at run time (the stage you are using the SQL builder from must allow job parameters for this to appear).
- Expression. An expression editor dialog box appears, allowing you to specify an expression that represents the value to be used in the query.
- Data flow variable. A dialog box appears offering you a choice of available data flow variables (the stage you are using the SQL builder from must support data flow variables for this to appear)
- Lookup Column. You can directly select a column from one of the tables in the table selection canvas.