Working with Filenames and Directories

Consider the following scenarios.

  • Every day we export data from our database and would like to save it into a different file using the current date as a part of the file.
  • We would like to load yesterday’s data from the folder which has date part in the name

We can use functions in filenames to do it as follows

GETSYSTEMVARIABLE('SYSTEM_DATE') will return current date in ‘YYYYMMDDHHNNSS’ format

If we want only part of the date we can use LeftString(String,Count):String for example

LeftString(GETSYSTEMVARIABLE('SYSTEM_DATE'),8) will return only date part.

Now more complicated example for loading yesterday’s data;


Another example:


For complete reference of available functions consult Supported Functions List

Only one {} pair is allowed.

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

  • aetle/packages/filenames_and_directories.txt
  • Last modified: 17/09/2018 10:34
  • by admin