I have an SSIS package that is calling the FTP script task. I can run the package from the package-store. Unfortunately, when I attempt to run it as a job I get the pretty common error: "Unable to connect to FTP server using 'FTP Connection Manager'."
I have been searching for solution. This is a pretty common problem and many people have offered answers. Unfortunately, I have not seen the solution that works for me. Here are a few of the pages that I've looked over:
The package is reading the user name, password and server name from a table. (Not a config file and the settings are not hard-coded.) Prior to the FTP task, I have a script task where I execute this code:
FTPConnectionManager = Dts.Connections("FTP Connection Manager")
Both the "FTP Prep" task and the FTP task that follows it have "DelayValidation" set to true.
The package works beautifully when I right-click on the package and run it from the package store! The job is configured to run under a proxy using my credentials. That still doesn't enable me to get the FTP task to work.
Finally, I have tried to save the package using "ServerStorage" and this did not change anything. Also, I don't wish to apply a password to the package because it is going to be used by multiple people over time and I don't wish to have to use a password to open the package.
Does anyone have any ideas? Thanks!