SSIS (DTSX) Execute package failing on production server.

So I have created a SSIS package and it works great on my dev machine. But, when I try to run it on the production server, it errors our on me.

Here is there error:

---

Error: The AcquireConection method call to the connection manager "DestinationConnectionOLEDB" failed with error code 0xC0202009.

---

I have figured out the cause, but am not sure how to get it fixed. The password isn't in the connection string. But I have set the password in the SSIS project. For some reason though, when I deploy and run this on the production server, it won't run since the password isn't part of the connection string.

Is there some setting in the SSIS project that I need to change in order to get this to work right?

Thanks.

From stackoverflow TehOne

• Disable the password by setting the ProtectionLevel in the package properties to DontSaveSensitive.

  I also recommend moving the connection string to a package variable and make an expression on the connection. Enable package configurations.

  Then you are free to change the connection and to use integrated security or not without changing the package. You can either put the connection string in the configuration or then provide it on the command line.

  TehOne : Thanks! This did the trick and also enabled a bit more flexibility.
  From Cade Roux

• Anyone else had a problem with this? I get a package validation error:

  DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER

  Error code = 0xC0202009

  Mr Shoubs : The database was rejecting me, it wasn't SSIS at all
  From Mr Shoubs

• these solutions all work: http://support.microsoft.com/kb/918760

  theres even a video: http://msdn.microsoft.com/en-us/library/dd440760.aspx

  but it didn't for me to start with as the database was rejecting my connection, so check that first

  From Mr Shoubs