Defining Project Variable Values

The Project Variable Values for the current execution are presented like this:

Each identifier corresponds to a project variable that has been defined for this project.  For more information on creating project variables see the article: Defining Project Variables.

The values are initially blank unless the project is being re-scheduled or the values were set as part of a source filtering source count operation.

To enter a value for a variable, select the corresponding row in the table, then enter the value directly into the Value column.  If you want to set the variable to NULL, select the row for the variable and click on the Set Null button.   To save the current settings without executing, use the Save Settings button. All variables must be defined before the execution can begin.

If you have chosen to use the LAST_EXECUTION_TIMESTAMP variable then this will automatically be set to the date/time that the last execution started. To include all records in the first run, it is advised to set it to a very early date/time (e.g. 1970-01-01 00:00:00) Setting it to NULL (by using the Set Null button) works for some server types (e.g. ServiceNow) but cannot be relied on and may result in an empty retrieval set or an error.