Using variables
What are the variables?
Variable has a name and a value. During execution, the variable name is replaced with a value. Variables provide a convenient way of passing parameters between various objects. They also can be used to store settings between sessions.
Global Variable
BDE Connection using Global Variable
Using variables to loop through the list of directories
Package Example
Lists files in directories and saves it into the file.
The file name is saved into the variable.
Loop loads list of files and loops through the list one by one
Script sets variable <BDEDIR> to directory path
Transformation loads the data
Video Tutorial:
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