File To Variables Dynamic Action

About

The File To Variables Action loads variable values from a delimited file, where the first field represents the variable name and the second field represents the variable value, ignoring any additional fields. This action is typically used to load parameters from a .env file.

Metadata tab

File To 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

File To Variables Action - Parameters tab
 

Variables tab

The Variables tab defines which variables are updated during the execution of the action.

File To Variables Action - Variables tab

Execution log tab

The Execution Log tab is populated after the action has been executed. Double-click a row to view the detailed execution log.

File To Variables Action - Execution log tab
  1. Load Variable Action
  2. Save String Action
  3. Delete Variable Action
  4. Select Value Action
  5. Set Variables Action
  6. File Line to Variables Action
  7. SQL Record to Variables Action
  8. SQL to Variables Action
  9. Command Line Parameters Action

Video Tutorial



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

Confused? Ask question on our ETL Forum

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