FTP Task will not execute when scheduled as a job

I have a job that runs a SQL script and creates a flat file. I use an FTP task to send the file to a specific FTP site. The job work beautifully when is is completed in the development environment.

After I build the package and deploy on the SQL server and set it up to run as a job it will not work on the SQL server. The error appears to be in the FTP connection. I get two separate errors:

'Unable to connect to FTP Server using FTP Connection Manager' and

'An Error Occured in the requested FTP operation. Detailed error description: The Password was not allowed'

I am sure something very simple is wrong.

Any thoughts.

Steve




Answer this question

FTP Task will not execute when scheduled as a job