SSIS:SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. Error code 0xC020801C,0xC02...

最新推荐文章于 2021-04-05 06:38:17 发布

weixin_30417487

最新推荐文章于 2021-04-05 06:38:17 发布

阅读量502

点赞数 1

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/HlxDo/p/4549464.html

本文介绍了解决在使用SSIS进行Excel数据导入时遇到的SSISErrorCodeDTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER错误的方法。通过调整项目属性设置可以有效避免这一问题。

The error info:

[Excel Destination [20]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0209303. There may be error messages posted before this with more information on why the AcquireConnection method call failed.

[SSIS.Pipeline] Error: Excel Destination failed validation and returned error code 0xC020801C.

The solution:

1.单击解决方案中的Project,