sql – SSIS连接在程序包中找不到

前端之家收集整理的这篇文章主要介绍了sql – SSIS连接在程序包中找不到前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。
我对SSIS编程很新,我在部署SSIS包时遇到了一些问题.

这个包在我的电脑上运行正常,做了所有需要做的事情,但是当我部署它无法找到连接字符串.

这是错误

Code: 0xC001000E Source: Description: The connection
“{DA7CD38D-F6AA-4B06-8014-58BEE5684364}” is not found. This error is
thrown by Connections collection when the specific connection element
is not found. End Error

Error: 2012-08-09 00:21:06.25 Code: 0xC001000E Source: Package
Description: The connection “{DA7CD38D-F6AA-4B06-8014-58BEE5684364}”
is not found. This error is thrown by Connections collection when the
specific connection element is not found. End Error

Error: 2012-08-09 00:21:06.25 Code: 0xC001000E Source: Package
Description: The connection “{DA7CD38D-F6AA-4B06-8014-58BEE5684364}”
is not found. This error is thrown by Connections collection when the
specific connection element is not found. End Error

Error: 2012-08-09 00:21:06.25 Code: 0xC00291EB Source: Execute sql
Task Execute sql Task Description: Connection manager
“{DA7CD38D-F6AA-4B06-8014-58BEE5684364}” does not exist. End Error

Error: 2012-08-09 00:21:06.25 Code: 0xC0024107 Source: Execute sql
Task Description: There were errors during task validation. End
Error DTExec: The package execution returned DTSER_FAILURE (1).
Started: 00:21:04 Finished: 00:21:06 Elapsed: 1.888 seconds. The
package execution Failed. The step Failed.

解决方法

您的ssis包似乎指向可能已被删除重命名的其他连接.尝试打开SSIS组件并指向连接管理器中的正确连接.

当我们复制SSIS包组件来创建一个新的包或者因为重命名连接或者可能仍然使用在xml配置文件中定义的旧连接的组件(在你的情况下,请尝试检查执行sql任务抛出错误).如果要使用XML进行配置,请尝试部署新的.

猜你在找的MsSQL相关文章