Set Variables Dynamic Action

About

The Set Variables Action provides a convenient method for assigning values to multiple variables.

Metadata tab

Set Variables 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

Set Variables Action - Parameters tab

Variables tab

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

Set Variables Action - Variables tab

User Defined Variables tab

Set Variables Action - User Defined 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.

Set Variables Action - Execution log tab
  1. Load Variable Action
  2. Save String Action
  3. Delete Variable Action
  4. Select Value Action
  5. File to Variables Action
  6. File Line to Variables Action
  7. SQL Record to Variables Action
  8. SQL to Variables Action
  9. 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 • 1 min read • 208 words
www.etl-tools.com About Support Pricing Cookies Policy Term Of Use Privacy Policy License