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:

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

Note:

Only one pair of {} is allowed

For example:

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

For more technologies supported by our ETL Software see Advanced ETL Processor Versions and Visual Importer ETL Versions

Confused? Ask question on our ETL forum

  • aetle/packages/set_variable_action.txt
  • Last modified: 30/06/2019 11:28
  • by admin