dopydb (4/17/2014)
hii 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?
Try using configurations:
Understanding Integration Services Package Configurations
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP