Load Variable Dynamic Action

About

This action loads file content into a variable.

Metadata tab

Load Variable Action - Metadata 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. This option is typically used for debugging and is not recommended in a production environment.
  3. It can be globally disabled through the options dialog .

Parameters tab

Load Variable Action - Parameters tab
 

Variables tab

The Variables tab defines the variables to be updated during the action’s execution.

Load Variable Action - Variables tab

Execution log tab

The Execution log tab is populated after the action is executed. Double click on the row to view the log.

Load Variable Action - Execution log tab

Calculated File name example

Pascal

Load Variable Action - Calculated File name example - Pascal
  Script

begin
 Result:='c:\support\'+LeftString(GETSYSTEMVARIABLE('SYSTEM_DATE'),8)+'.msg';
end;

Python

Load Variable Action - Calculated File name example - Python
  Script

from datetime import datetime
Result.Value='c:\\support\\'+ datetime.now().strftime('%Y%m%d')+'.msg'
  1. Load Variable Action
  2. Save String Action
  3. Delete Variable Action
  4. Select Value Action
  5. File to Variables Action
  6. Set Variables Action
  7. File Line to Variables Action
  8. SQL Record to Variables Action
  9. SQL to Variables Action
  10. Command Line Parameters Action

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

Confused? Ask question on our ETL Forum

Posted on November 14, 2025 • 2 min read • 280 words
www.etl-tools.com About Support Pricing Cookies Policy Term Of Use Privacy Policy License