FTP Connection Manager Password in Child Package

Question

I have a package made up of several "Execute Package Task" items. The first to execute is a simple package that does some directory preparation and then retrieves files from an FTP site. It works fine run independently, but when the parent package is run it fails in the first child package with the message:

[Connection manager "FTP Connection Manager"] Error: An error occurred in the requested FTP operation. Detailed error description: The password was not allowed.

It seems clear the password in the FTP Connection Manager in the child package is not available when the package is run as part of a parent package. Both the parent and child packages are saved with EncryptSensitiveWithPassword. I have pored through the properties of both the parent and child packages, but am clearly missing something.  What do I need to do to get this to work?

---

Echo Train Nashville TN

Answer 1

Hi,

How about storing the password/connection string via package variables and evaluate expression as true upon runtime?

You can then configure the child package to use parent variable for the password.

---

MCTS, MCITP: BI Technical Consultant| Karabina, South Africa Blog: www.selectsifiso.net

Answer 2

Thanks for the response, M. Ndlovu. I understand how to set package variables, but do not know what you mean by "evaluate expression as true upon runtime." Will you please elaborate?

---

Echo Train Nashville TN

Answer 3

Hi Echo Train,

I suggest you using package configurations to save password for the child package, save the ConnectionString property to the configuration file, then edit the configuration file in Notepad, and add the password back into the connection string. For more information about Integration Services Package Configurations, please refer to: http://msdn.microsoft.com/en-us/library/cc895212.aspx 

Please feel free to ask if you have any question.

Thanks,
Eileen

Answer 4

OK, Eileen, I will try this later on and post back.  Thanks for answering.

---

Echo Train Nashville TN

Answer 5

Thanks again, Eileen.  It took me a while to get back to this, but your suggestion is working.

---

Echo Train Nashville TN