SSIS Package AcquireConnection Error

I have an SSIS package that is returning the error message:

The AcquireConnection method call to the connection manager 'conn' failed with error code 0xC0202009

This is an OLE DB connection using the MIcrosoft version of the Oracle OLE DB driver.

I have verified that the connection works in Visual Studio, and have set the package property ProtectionLevel to EncryptAllWithPassword.

Any ideas?
cgulkaAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

HoggZillaCommented:
Save the package with ProtectionLevel to Rely On Server Storage and see if it works. If you save with a Password then you need to provide that password when you create the Job for SQL Server Agen.
0
HoggZillaCommented:
Also, in your connection manager, make sure you select "Allow Saving of Password".
0
cgulkaAuthor Commented:
The connection ais allowing for password saving.  I can't save the package on the server, so I am saving it to a dtsx file.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

HoggZillaCommented:
When you call it you will have to supply a password. What means are you using to execute? If you double click on the file it should open a configuration window that will result in creating the command line. Try this, it will allow you to enter your password for the file that you created when you saved the package.
0
cgulkaAuthor Commented:
That is exactly how I am running the package, and when I run it with the password is when I get the error.
0
HoggZillaCommented:
OK, just to be clear. We are talking about the password YOU choose when you save the SSIS package with ProtectionLevel.
0
HoggZillaCommented:
Here are m screenshots. Choose Save Copy of Package as...
You may already be doing this exactly correct but i want to make sure we are on the same page.

protection-level-pwd2.bmp
save-copy-to-file-pwd.bmp
0
HoggZillaCommented:
When I run the package or attempt to configure, I have to provide the Password I created. Are you here so far?
enter-my-pwd.bmp
0
cgulkaAuthor Commented:
Yes, I have done all this.  The error comes when the package tries to execute.
0
HoggZillaCommented:
OK, past the Script Task code here. I see the specific error referring to "conn" which is the name of a connection object in your task. Let's see where we get from there.
0
cgulkaAuthor Commented:
OK, so I have narrowed down the problem.  It seems to happen only when I load the user and password from a .dtsconfig file.  I'm assuming that SSIS won't use the password from that file since it isn't encrypted.  Does this sound right?  If so, how do I get past this?
0
cgulkaAuthor Commented:
OK I've figured it out.  When creating the .dtsconfig file, the password is not saved, you have to put it in manually.  Problem solved.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
HoggZillaCommented:
Very good.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.