Thanks for reply..you gave a useful hint about netrc files..I looked up about netrc files, and this idea seems to offer protection in the sense that only right people with access can look at contents of netrc file;
However I am not sure if encrypted password is placed in netrc file, DOS-FTP would work;
First of all, why can't you stick with filename ftp?
Second, I think would get more luck on a different forum than these ones at this site, since SAS has nothing to offer if you chose to perform the processing outside SAS (by using X statement).
Then it's not clear what you want to protect. A password in a scrip tfile can be protected by using file system security. You might also consider that ftp offers no proection during communication. In this case you could consider using the sftp protocol instead.
I have been testing both filename FTP and DOS-FTP for some time now; And before moving code to production I want to be able to give pros and cons of both approaches to my management;
I found several limitations using standard filename FTP, however I was able to come up with a solution which would allow me to gracefully terminate system and make another attempt to download files, in case of various failures (network connection lost/remote file moved etc);
DOS-FTP never gave me any issues at all, but looks like the major draw back is it will not allow to encrypt password; The requirement at my client site is that the actual password should not be stored anywhere, even in netrc files, and it should not appear in log files either. And entering this password when prompted is not an option (the process is used to download dozens of files daily from Bloomberg server);
so basically, I have been thoroughly exploring all options..and I want to ready with an answer if someone from client team asks me reason not to use DOS-FTP;