May 12, 2014 at 8:37 am
I have a package with 2 connection managers. One is called SSISConfig and is set to use an enviroment variable configuration pointing to the database that will be holding the configuration for the 2nd connection manager. The 2nd configuration is a SQL Server one and I can see the rows in the table for this connection manager. I have to use SQL Server authentication with a username and passoword. The pasword is correct in the ssis_configurations table but Im getting the following error when I try to run the package:
[Care Alert from HEDIS [297]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "MyConnxMgr" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
Why am I getting this error? I open the connection manager in VS and test connection and its fine.
May 12, 2014 at 8:40 am
So how are you executing the package?
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
May 12, 2014 at 8:47 am
Right now I'm trying to test it in Visual Studio. Am I correct in assuming that what ever is in the configuration will overwrite whats in the package?
May 12, 2014 at 9:02 am
I have it running now. I'm thinking that the issue was that even after creating the SQLServer configuration I needed to go in and manually update the connection string to include the password as well as manually update the password config
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply