• I'm trying to imagine any single chore harder in this world of IT then getting the SSIS FTP task to work when run as a job. Why does Microsoft heap so much misery on us poor developers? They have money for examples, they have money for tutorials. This is extraordinarily painful!!!

    I have been busy trying everything I can think of to get this work. I'm running in 32-bit mode. I have set the user name, server name, port, passive mode and password values in a config file that I load via Package Configurations. I've set a password on the package. I've specified the package protection level to "EncryptSensitiveWithPassord." I've set the MaxConcurrentExecutables to 10. Saved to my Integration Services server.

    I've tried changing the command line so that it has the "Decrypt" option. I've added my package password after the 'Decrypt' switch, then copied the line to notepad. From there I typed it in exactly into a command window.

    I get the same error every time: "Unable to connect to FTP server using 'FTP Connection Manager''. Thanks, Microsoft!!

    Any morsel of help for this most laborious of tasks is appreciated. Thanks.