i have an ssis job, which runs various calculations, creates a .txt file and then uploads to an FTP site.
when i run it in bids it works fine, but when i schedule to run using sql agent, it fails with the below error..
"An error occurred in the requested FTP operation. Detailed error description: The password was not allowed"
how should i be saving my FTP password?