When attempting to use the FTP connection in automation services to download files, one can transfer files from a remote directory to a local directory using an FTP connection. However, when attempting to do the same using the FTP connection in automation services the process files with the error message:
"FTP_1 - Access to the path ‘<path_name>' is denied." This file was not available at runtime. The location and user authentication may be different at runtime.
Waiting for fix in a future version of Toad Data Point.