File Loop Dynamic Action

About

The File Loop Action processes each line of a delimited file, assigning values to variables based on the column names specified in the file header.

File Example

File Loop Action - File example

Metadata tab

File Loop 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 Loop Action - Parameters tab

Variables tab

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

File Loop 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.

File Loop Action - Execution log tab
  1. IMAP4 Email Loop Action
  2. Office 365 Email Loop Action
  3. Files Loop Action
  4. Database Loop Action
  5. Down Loop Action
  6. Up Loop Action
  7. Json Object Loop Action
  8. Json Array Loop Action

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

Confused? Ask question on our ETL Forum

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