Database Loop Dynamic Action

About

The Database Loop Action iterates through database records, assigning values to variables based on the field names.

Data Example

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

Tip: When the “UseEmbeddedSQL” is set to True EmbeddedSQL is used, otherwise SQL Script/Lookup is used.

Resuming Loop Execution After Failure

1. When Resume Loop is true current loop position value is saved into Loop Position File automatically
2. The same file is used to resume file execution after failure
3. Upon successful completion the Loop Position File is deleted

Selecting Connection

Selecting Source Script/Lookup

Editing Script

Variables tab

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

Execution log tab

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

Related Actions

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

Useful Links

• Debugging Actions
• Working With Variables

Posted on September 17, 2025 • 2 min read • 298 words