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

Specifies which variables will be set once action execution is completed

• Date formats
• Best practice for Calculations
• Scripting Language
• Supported Functions List
• Working with python

• Advanced ETL Processor Professional and Enterprise Documentation
• Visual Importer ETL Professional and Enterprise Documentation
• Download Python