I have an 2008 SSIS package with an FTP step. I enter the FTP info into the FTP Connection Manager and the package will execute successfully. However it will not retain the FTP password even after saving the package. Any ideas?
Try to right-click on your **FTP Connection Manager** and choose **Properties**. Type your password and then, when you get to saving your package, save it with **EncryptSensitiveWithPassword** option. This is different from the default **EncryptSensitiveWithUserKey** option, which will, for example, fail to run your package when you setup a job, because the account is not going to be consistent with yours (the one used to create SSIS package). Oleg