Insert value
This property identifies the values that you are setting the corresponding column to. You can enter a value manually or specify a job parameter, expression, data flow variable, or lookup column.
When you specify a value, you can use the following objects:
- 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.