There are several new ETL Package objects in the latest version of Advanced ETL Processor:
What are the Package variables?
Package variables provide a convenient way of storing/accessing temporary data.
Note:
- Package variable name can be any string.
- It is not recommended to use very short names for package variables, for example, the user can call a variable “I” and set the value to Test. This might create problems later because It would be replaced with “Test”, so “C:\Program files” would become “C:\Program ftestles”
How Package variables can help business process automation?
There are several ways Package variables can benefit the user:
What are the ways of accessing and modifying package variables?
Script package object allows writing additional complicated checks and validations.
It supports all functions used by Calculation object + variables' functions.

Example:
Var I : Integer;
begin
I:=1;
SetVariable('I',I);
I:=GetVariable('I');
WriteToLog('Error',I);
Result:=True;
end;
Result:=True; => Succes
Result:=False; => Failure
Set Variable package object is a convenient way of changing package object properties dynamically.
Once the variable is set, it will be replaced with the actual value for the objects executed after.

System variables
System variables are used to provide the user with additional information.
For example, SQL script has failed and the user would like to email the SQL to the developer. Insert <Sql Script> into email message body and it will be replaced with actual SQL automatically
List of system variables: | ||
<username> <computername> <datetime> <Package Name> <Current Package Item Name> <Actual Execution Status> <Execution Status> <Main Package Log Name> <Package Item Log Name> <Rejected Records File Name> <LAST EMAIL> <SMTP Log> <SMTP Email> <SMTP Subject> <SMTP Message> <Check Sql> <Check Sql Value> <Source File> <Source Directory> <Source Database> <Source Server> <Source UserName> <Source Password> <Transformation Processed> <Transformation Errors> <Transformation Rejected> <Transformation Records/Sec> <Transformation Log>' |
<Sql Script> <Sql Log> <Application File Name> <Check File Name> <File To Compare 1> <File To Compare 2> |
<POP3 Email> <POP3 Directory> <Report Export File>
|
Usage examples:
- Using cycles to load data from multiple directories

- Package variables in File Operation properties dialogue
