|
我对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进行配置,请尝试部署新的. （编辑：李大同）
【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!
|
