Debugging Package

Getting started

Individual actions within the package can be executed independently, or the entire package can be debugged. Breakpoints can also be set to facilitate controlled debugging.

Break Point

To start debugging click green arrow.

Start Debugging

Action in blue is being currently executed.

Debugging Package

Read arrow continues execution of package after the breakpoint

Debugging Package

Execution log

Click to show execution log

Execution log

Execution log provides additional information about the package actions

Execution log

Package log

Double click on the line to see the log

Overall package log

Action log

Action log

Ask Question Action - Execution log tab

Variables

Package variables are used to store and manage data within a package, enabling dynamic and flexible execution. They act as placeholders for values that can be referenced, modified, and passed between different actions in the package.

Package Variables

Tracking Variable changes

A single variable can be modified by multiple actions. Tracking these changes can be done using the “Write Variables” option.

Write Variables Option

  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 not recommended in a production environment.
  3. It can be globally disabled through the options dialog .

Variables tab

This tab displays all variables and their values prior to the execution of an action.

Variables Tab

Variables Updated tab

This tab displays the variables that are updated by the action.

Variables Tab

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

Confused? Ask question on our ETL Forum

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