Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER error

Tags:

ssis

My package consists of dynamic db connections. When i run my package it is throwing error like DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.The AcquireConnection method call to the connection manager "conn" failed with error code 0xC0202009.

I tried setting delay validation property to true at package level.

I tried to change Package Protection Level property to EncryptSensitiveWithpassword. Still am facing with same error.

Am able to run the package manually.

How to get rid of this.

like image 570
user1348424 Avatar asked May 08 '12 05:05

user1348424


1 Answers

This can be solved in 2 ways

First, i have changed my delay validation property at package level to True from false.

Change ProtectionLevel to EncryptSensitiveWithUserKey.

Second, Remove the old connection manager and create new one.

Most of the time first way solves the problem.

like image 134
user1348424 Avatar answered Nov 04 '22 12:11

user1348424