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