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

FTP Task will not execute when scheduled as a job
Kevin MacDonald
One possible problem is package protection level: the default one is very convenient (you don't have to type anything), but only the user who saved the package can decrypt its secrets (like FTP password).
So either change protection level to password or server-based one, or create proxy for your account:
http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=57422&SiteID=1
http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=237837&SiteID=1