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

24/06/2015 14:09 · kevin
  • vimpe/packages/filenames_and_directories.txt
  • Last modified: 26/06/2015 10:16
  • by admin