Set Variable Legacy Action

About

Set Variable package action is a convenient way of changing package object properties dynamically. Once a variable is set, it will be replaced with the actual value of the objects executed after. Package variable name can be any string. It is not recommended to use very short names for package variables, for example, the user can a variable “I” and set value to Test. This might create problems later because the letter I will be replaced with “Test” so “C:\Program file” will become “C:\Program ftestle”

Workflow tab

1. The Write Variables option ensures that the “Package Action” logs the variable values into the “Action vars before log file” before the action is executed and logs the updated variable values into the “Action vars after log file” after the action completes.
2. It is usually used for debugging and not recommended for production environment.
3. It can be globally disabled using options dialogue

Example

Variables tab

After execution tab

Specifies which variables will be set once action execution is completed

It is possible to use calculations inside variable by placing calculation inside {}

For example:

C:\Data{GetSystemDate('YYYYMMDD')}.vis

Example: Loading variables from database