Script Action

Script package action allows writing additional complicated checks and validations.

Two languages are supported:

  1. Pascal Script
  2. Python

Pascal Script Example:

Var I : Integer;
begin

I:=1;
SetVariable('I',I);
I:=GetVariable('I');
WriteToLog('Error',I);
Result:=True;
end;

Result:=True; ⇒ Success Result:=False; ⇒ Failure

Python Example:

import etltools
etltools.SetVariable('<Time>',15)
s=etltools.GetVariable('<Name>')
etltools.WriteToLog('Done')
Result.Value = 0

Result.Value = 1 ⇒ Success Result.Value = 0 ⇒ Failure

Expression builder only works with Pascal script

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

Confused? Ask question on our ETL forum

  • aetle/packages/script_action.txt
  • Last modified: 17/09/2018 09:42
  • by admin