Symptom
- Using EXEC() function in postload script to execute a .bat file which contains to move the file from one location to another and rename the file with date stamp.
- Exec syntax: exec($G_BATCHFILE, ' ', 8);
- Viewing the logs when after executing the task you see access denied and syntax error.
- 2019-03-13 05:14:17 (2212:4480) DATAFLOW:Process to execute data flow <Task_MTP_MD_Location_FF_DF_Location_Master_FF> is completed.
- 2019-03-13 05:14:18 (1524:8052) PRINTFN:1: Access is denied. 0 file(s) copied. The syntax of the command is incorrect.
- Script uses substrings of %time% and appends to a file name using REN
- @ECHO OFF
- rem get the current date in format YYYYMMDD
- set mydate=%date:~10,4%%date:~4,2%%date:~7,2%
- rem get the current time in format hhmmss where hh is in 24-hour time
- set mytime=%time:~0,2%%time:~3,2%%time:~6,2%
- COPY <full path to original data file> <folder where the file is to be moved>
- REN <full path to data file including name & extension> <file name>_%mydate%_%mytime%.csv
Read more...
Environment
SAP Cloud Platform Integration for data services
Product
SAP Cloud Integration for data services all versions
Keywords
KBA , LOD-HCI-DS , HANA Cloud Integration for Data Services , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.