Skip to Content
Former Member
Feb 01, 2018 at 06:46 PM

How to copy files in azure Blob if the container does not exist?

1225 Views Last edit Feb 01, 2018 at 06:49 PM 4 rev

Hello All,

First of all thanks to sap for SAP DATA SERVICES 4.2 SP10 .

The requirement in short is below: Getting data sap ecc and put the data in a file in a local shared directory where file name will be <file name>_<system date >.csv and then copy the file to Azure blob and then to Azure data lake store(ADLS).

I developed the job and upto ADLS and BLOB it is working absolutely fine.

But the problem that I am facing is :

Suppose the Blob container name is : 'bodsfile' ,so file that will be generated today should be placed in the path bodsfile/ <current Year>/ < current month>/ <current day> .

(eg. /bodsfile/2018 /02 /02 ) in the azure blob container.

In the sap Guide it clearly written that we can place the file in existing container as well as u can also create container in azure storage but I did not find any option in the flat file location object .I have created the flat file loc object with protocol azure container .

Can any one help me with this also can I use parameter or gv in the flat file location object as it can only be accessed using the function .