Dynamic timestamp in filename for EPM Pipeline Copy to SFTP
Hi,
We are replacing an existing server-based file transfer process with an EPM Pipeline in EPCM application.
Currently, the EPCM Pipeline exports a .DAT file with a fixed filename. A PowerShell script on a server downloads the file, appends the current date and time, and uploads it to an Azure Storage SFTP location.
Example:
Original: sample.dat
Renamed: sample_202608250725.DAT
The downstream application requires a unique filename for every delivery.
We want the EPM Pipeline to:
Run the data export.
Generate a unique filename in the following format:
sample_<yyyyMMddHHmm>.DAT
Send the file directly to Azure SFTP using the Copy to SFTP job.
Tagged:
0