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