How to create the destination file name dynamically with time stamp?
We can create the destination file names like CSV,TXT,XML with dynamic date names in SAP BODS.
Create a job with Script > Data flow
$G_Filename = ‘Dynamic_File_Name_’||substr(sysdate(),0,10)||’.csv’;
Declare the variable $G_CurrentDate as date and $G_Filename as varchar.
Place this variable $G_Filename in the File name of the File Format Editor
Create the Global Variables:
Create the data flow with the following:
Create a file format Editor
Choose the directories for destination file path.