Action Parameters

Double-click on the action to edit its properties.

Metadata tab

Show Message 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

Show Message Action - Parameters tab

Actions come with four types of parameters: Static, Variable, EnvVariable and Calculation

The values for these parameters are calculated or assigned based on their type before the action is executed.
This approach simplifies the process compared to performing calculations directly within text boxes.\

Static parameter

A static parameter value can be updated directly or through the edit dialog.

Static Parameter Text

Multiple edit dialogs are available, such as the File Select dialog, Connection Select dialog, Folder Select dialog and more.

Variable parameter

Variable Parameter Text

  • Variables are substituted with their actual values before the action is executed.
  • Multiple variables are supported.
  • The Variable Selection dialog is populated after the package is executed.
  • Double-click on the parameter to open the text editor.

Env Variable parameter

Environment Variables are key-value pairs used by an operating system and applications to store configuration settings, system information, and operational parameters. They provide a dynamic way to influence the behavior of processes and programs without modifying code.

Env Variable Parameter Text

Calculated parameter

Calculated parameters provide a powerful way to make workflows more intelligent, adaptable, and error-proof while reducing maintenance overhead and enhancing overall efficiency.

Examples of Calculated Parameters:

  • Generating file paths based on user IDs and timestamps.
  • Deriving API endpoints dynamically based on region or system state.
  • Using expressions to select different data sources or configurations.

Pascal example

Show Message Action - Calculated Message example - Pascal
  Script

begin
  Result:='Today is '+DateToStr(Now);
end;

Python example

Show Message Action - Calculated Message example - Python
  Script

import datetime;
if datetime.datetime.today().weekday()==0:
   Result.Value='Weekend'
else:
   Result.Value='Weekday'

Variables tab

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

Show Message 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.

Ask Question Action - Execution log tab

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 22, 2025 • 3 min read • 431 words
www.etl-tools.com About Support Pricing Cookies Policy Term Of Use Privacy Policy License