Set Variable Action

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”

Example:

Specifies which variables will be set once action execution is completed

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

Note:

Only one pair of {} is allowed

For example:

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

• Advanced ETL Processor Professional and Enterprise Documentation
• Visual Importer ETL Professional and Enterprise Documentation