I have an SSIS package that uses an FTP connection manager. When running the package in BIDS, it runs fine and maintains the password for the remote ftp site's user account.

Once I deploy the package and attempt to run it, it fails with the following error:

Started:  4:06:15 PM
Error: 2015-08-27 16:06:20.09
   Code: 0xC001602A
   Source: Export and FTP New Jobs Connection manager "FTP Connection Manager"
   Description: An error occurred in the requested FTP operation. Detailed error description: The password was not allowed
End Error
Error: 2015-08-27 16:06:20.09
   Code: 0xC002918F
   Source: FTP Jobs Listing to Concur FTP Task
   Description: Unable to connect to FTP server using "FTP Connection Manager".
End Error
DTExec: The package execution returned DTSER_FAILURE (1).

I've tried Don't Save Sensitive With Password and that still fails.

Does the FTP connection manager just not retain passwords outside of BIDS??

Any input would be appreciated!

Thanks!

What do you have specified for package protection level when you deploy it and fails?

I've tried Don't Save Sensitive With Password and that still fails.

Does the FTP connection manager just not retain passwords outside of BIDS??

This link explains above issue.

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/b24874e3-dfd3-47ce-ab51-35bea3714019/ftp-connection-manager-looses-password-?forum=sqlintegrationservices

how to resolve this in SSIS 2012 and above, see below

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/bead2b48-13bb-4962-9d5f-df81a6f34697/ftp-connection-manager-the-password-was-not-allowed?forum=sqlintegrationservices