DTS_E_CANNOTACQUIRECONNECTIONFROMC ONNECTIONMANAGER
All, Ive come across an issue with a newly created package. Several error messages are receved relating to the package's connection managers. Each connection managers tests successfully.However, the errorsare thrown during package execution. A similar issue was encountered in a separate package. It was resolved by temporarily disabling package configurations.That doesn't help in this case. I did read other posts regarding package protection level which wasn't helpful in this case. Any assistance you can provide would be helpful! Thanks for your time, Orlanzo ====================================================================== SSIS package "StageRef-Tier2_ODRBOND.dtsx" starting. Information: 0x4004300A at Stage data to _Temp tables, DTS.Pipeline: Validation phase is beginning. Error: 0xC0202009 at StageRef-Tier2_ODRBOND, Connection manager "Sybase.TIER2.odrisk": SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. Error: 0xC020801C at Stage data to _Temp tables, ODRRisk_OTRData [1]: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Sybase.TIER2.odrisk" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. Error: 0xC0047017 at Stage data to _Temp tables, DTS.Pipeline: component "ODRRisk_OTRData" (1) failed validation and returned error code 0xC020801C. Error: 0xC004700C at Stage data to _Temp tables, DTS.Pipeline: One or more component failed validation. Error: 0xC0024107 at Stage data to _Temp tables: There were errors during task validation. SSIS package "StageRef-Tier2_ODRBOND.dtsx" finished: Failure. The program '[2384] StageRef-Tier2_ODRBOND.dtsx: DTS' has exited with code 0 (0x0). ======================================================================
December 20th, 2007 3:36pm

Are you executing the package on your machine when you get the error? Are you trying to save the password in the connection manager? Are you setting any property of the connection managers through configurations? What property?
Free Windows Admin Tool Kit Click here and download it now
December 20th, 2007 3:44pm

Yes, I am executing the package on my machine when the error occurs. Yes, the password is saved in the connection manager. I am not setting any property through a configuration (I've disabled them in the package for testing and will enable them once my level of testing is complete.)
December 20th, 2007 4:03pm

Did another developer create the package? Did you create the package on another machine? Try setting the password through a configuration.
Free Windows Admin Tool Kit Click here and download it now
December 20th, 2007 9:06pm

Anthony, Thanks for the follow-up.... Yes, another developer created the original package. I'm using a copy of that package. No, the copy I'm using was created on my machine. I'll try using a configuration for the connection and report back. Orlanzo
December 21st, 2007 7:58am

Anthony, I created a new configuration for the connection. That took care of it. Thanks for the help!! Orlanzo
Free Windows Admin Tool Kit Click here and download it now
December 23rd, 2007 4:07pm

Can you tell me what you did here to fix the issue.I am having the same issue.
August 12th, 2009 3:10pm

I added a new package configuration to set the password at runtime.Orlanzo
Free Windows Admin Tool Kit Click here and download it now
August 12th, 2009 3:50pm

Try changing the PROJECT to run in 32-bit mode by right clicking on the Project - Properties - Debugging - Set 'Run64BitRunTime' to False. It worked for me.
June 2nd, 2012 10:42am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics