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.
- 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.
Var I : Integer;
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 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:|
<Current Package Item Name>
<Actual Execution Status>
<Main Package Log Name>
<Package Item Log Name>
<Rejected Records File Name>
<Check Sql Value>
|<Sql Script> |
<Application File Name>
<Check File Name>
<File To Compare 1>
<File To Compare 2>
<Report Export File>
- Using cycles to load data from multiple directories
- Package variables in File Operation properties dialogue