Skip to Content
0
Dec 20, 2018 at 10:07 AM

Dynamically determine the Remote Directory of FTP File locations in SAP Data Services

1099 Views Last edit Jan 02, 2019 at 07:17 PM 2 rev

Hello,

In SAP Data Services, I have setup a file location of FTP protocol. The FTP destination has more than 10 directories under the root directory and each directory has its own directories inside. I would need to dynamically determine the directory location inside this FTP destination and place a flat file in it.

Initially I thought this is easy to solve by using a global variable in the 'Remote Directory' and I can write a script to determine the remote directory location and place it in the global variable.

However Data services do not allow me to use variable in the Remote directory setting of the file location. So I need to use a static location which does not solve my problem I have.

I cannot create multiple file locations for all the directories because there are hundreds of them.

Do you have any pointers on how to determine the remote directory dynamically?

Thanks,
Sandesh

Attachments

capture.png (10.1 kB)