Package Dynamic Action

Package Action provides a convenient way of grouping objects together so the logic can be used by multiple packages

To create a new Package Action, Drag and Drop it from the Object tree.

Metadata tab

Package 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

Package Action - Parameters tab

Selecting Package

Package Action - Editing Package Parameter

Variables tab

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

Package 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.

Package Action - Execution log tab

Calculated Package example

Pascal

Package Action - Calculated Package ID example - Pascal
  Script

begin
 if DayOfWeek(Now)=3 then
    begin
     Result:=4191;
    end
 else
    begin
     Result:=1968;
    end;
end;

Python

Package Action - Calculated Package ID example - Python
  Script

import datetime;
if datetime.datetime.today().weekday()==0:
   Result.Value=1407
else:
   Result.Value=1968

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

Confused? Ask question on our ETL Forum

Posted on November 29, 2023 • 2 min read • 228 words
www.etl-tools.com About Support Pricing Cookies Policy Term Of Use Privacy Policy License