DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER 错误 [英] DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER error

问题描述

我的包由动态数据库连接组成.当我运行我的包时，它抛出错误，如 DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.对连接管理器conn"的 AcquireConnection 方法调用失败，错误代码为 0xC0202009.

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.

我尝试在包级别将延迟验证属性设置为 true.

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

我尝试将包保护级别属性更改为 EncryptSensitiveWithpassword.仍然面临同样的错误.

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

我可以手动运行包.

如何摆脱这个.

推荐答案

这可以通过两种方式解决

This can be solved in 2 ways

首先，我已将包级别的延迟验证属性从 false 更改为 True.

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

将保护级别更改为 EncryptSensitiveWithUserKey.

第二，删除旧的连接管理器并创建新的连接管理器.

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

大多数时候第一种方法可以解决问题.

Most of the time first way solves the problem.

这篇关于DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER 错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！