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?
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?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Steve Hogg
Also, in your connection manager, make sure you select "Allow Saving of Password".
ASKER
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.
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.
ASKER
That is exactly how I am running the package, and when I run it with the password is when I get the error.
OK, just to be clear. We are talking about the password YOU choose when you save the SSIS package with ProtectionLevel.
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
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
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
enter-my-pwd.bmp
ASKER
Yes, I have done all this. The error comes when the package tries to execute.
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.
ASKER
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Very good.