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 Variables

Global Variables

Usage Example

BDE Connection using Global Variable

Using variables to loop through the list of directories

Package Example

Working With Variables Package

Lists files in directories and saves it into the file.

Working With Variables File Operation

The file name is saved into the variable.

File Operation Variables

Loop loads list of files and loops through the list one by one

Loop Properties

Script sets variable <BDEDIR> to directory path

Script Properties

Transformation loads the data

Video Tutorial

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

Confused? Ask question on our ETL Forum
Last updated: March 14, 2023