Show Message Dynamic Action

About

The Show Message Action is primarily used for debugging. When executed by the agent, it logs the specified message into the execution log.

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

Tip: Instead of writing complex calculations use “Replace Variables” parameter to replace variables inside question

Variables tab

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

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

Ask Question Action - Execution log tab

Show Message Action package example

Show Message Action - Package example

Calculated Message example

Pascal

Show Message Action - Calculated Message example - Pascal
  Script

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

Python

Show Message Action - Calculated Message example - Python
  Script

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

Video Tutorial


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

Confused? Ask question on our ETL Forum

Posted on September 24, 2026 • 2 min read • 264 words
www.etl-tools.com About Support Pricing Cookies Policy Term Of Use Privacy Policy License