DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "XXX" failed with error code 0xC0209303.

问题：

今天写了一个新的SSIS的ETL包，运行报如下错误。

DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. 

The AcquireConnection method call to theconnection manager "XXX" failed with error code0xC0209303. 

There may be error messages posted before this with more information on why the AcquireConnection method call failed.

 

解决：

在 Integration Services 包的“项目属性”中，通过在“调试”页上设置 Run64BitRuntime 属性的值为 False 以选择 32 位执行

步骤：顶部菜单-项目-属性（或....属性）-调试-在“调试”页上设置 Run64BitRuntime 属性的值为 False

 

之后再次运行就一切正常了。