Dynamic File names

It is possible to use calculated filenames by placing calculation inside {}

Note:

Only one pair of {} is allowed

For example:

1. This will use today date to generate the filename

C:\Data\{GetSystemDate('YYYYMMDD')}.txt

2. And that one will use yesterdays date

C:\Data\{DecDateS(GetSystemDate('YYYYMMDD'),'YYYYMMDD','DAY',1)}.txt

3. <CommonDocumentsDir>\DBSL\{GetSystemVariable('SOURCE_FILE_NAME')}.txt

Note:

<CommonDocumentsDir> is a variable and will be replaced with an actual value before execution

3. C:\Data{GetVariable('<file_name>')}.txt

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

  • vimpe/dynamic_file_names.txt
  • Last modified: 09/09/2020 06:20
  • by admin