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

Script Code:

$G_CurrentDate= sysdate();

print($G_CurrentDate);

$G_Filename = ‘Dynamic_File_Name_’||substr(sysdate(),0,10)||’.csv’;

print($G_Filename);

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.