I created a SSIS package with 3 FTP tasks which will recieve the files from FTP site and copy them to local folder. I created a FTP connection manager with username and password and Test Connection is Succeeded. Also, I configured a XML Configuration File since I'm scheduling my package to run daily. I know while build the Package the XML configuration file will be saved without passwords. So, I manually entered my passwords in the file and deployed the package. Its working fine from Sql Agent job. But when I'm trying to execute package from BIDS I'm getting the following error. An error occurred in the requested FTP operation. Detailed error description: The password was not allowed I think because the XML file is saving without passwords and the package is attempting to configure from the file. Please help me with this.

What is the protection level of your package (if it is do not save sensitive, then you need to provide the password)?Arthur My Blog

Protection Level: EncryptSensitiveWithUserKey

Then check the variables (I guess you just do not supply or supply the wrong password) using the watch window with breakpoints or log to console using FireInformation to inspect the contents of the variables.Arthur My Blog

I entered the password in Password field of FTP Connection Manager. What do you mean by variables? Till yesterday it was executed fine from BIDS as well. Today morning I edit the XMl Configuration file to add the new oledb connection manager into it. From then the problem started.

can you run just the ftp step? if it fails the issue is not in SSISArthur My Blog

I just ran the FTP step.Still the package is failing. The package is executed successfully when I removed the configuration file from package. Again its failed when I added the configuration file back to package. Executed successfully when I scheduled the package to run from SQL Agent. Deployed the package with configuration file and entered all the passwords manually in the xml file. Ques: Should we need to remove the Configuration file from package when the package is executing from BIDS?

No need. If the config is enabled and correct, it will be used.Arthur My Blog

But the configuration file will not save passwords for Connection Managers(ex: FTP Connection Manager) while build the project right? If yes, then how the Connection Mangers will connect ?

A config file is just a flat file that must contain the right password to connect, BIDS does nothing to it.Arthur My Blog

But in the following post Todd said SSIS does NOT extract passwords out to Configurations. http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/7b589173-5f27-44b8-a5ae-c0457793c9df

EncryptSensitiveWithUserKey is not good, it is not for deploying packagesArthur My Blog

So, does the configuration files will save the passwords or not ? But I'm deploying all my packages with Protection Level: EncryptSensitiveWithUserKey

The config will save. You must not deploy your packages with this option because it is your user key. Read this http://www.protalk.in/sql-server/steps-to-create-and-deploy-ssis-package-as-a-sqlagent-job/ (skip to "Deploying a package" section) Arthur My Blog