在包中找不到 SSIS 连接 [英] SSIS Connection not found in package
问题描述
我是 SSIS 编程的新手，在部署 SSIS 包时遇到了一些问题.
I'm kind of new to SSIS programming, and I'm having some problems deploying an SSIS package.
这个包在我的 PC 上正常运行，完成它需要做的一切......但是当我部署它时找不到连接字符串.
This package runs correctly on my PC, does everything it needs to do ... but when I deploy it cannot find the connection strings.
这里是错误:
代码:0xC001000E 来源:描述:连接《{DA7CD38D-F6AA-4B06-8014-58BEE5684364}》没有找到.这个错误是Connections 集合在特定连接元素时抛出没有找到.结束错误
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
错误:2012-08-09 00:21:06.25 代码:0xC001000E 来源:包说明:连接{DA7CD38D-F6AA-4B06-8014-58BEE5684364}"没有找到.当连接集合抛出此错误时未找到特定的连接元素.结束错误
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
错误:2012-08-09 00:21:06.25 代码:0xC001000E 来源:包说明:连接{DA7CD38D-F6AA-4B06-8014-58BEE5684364}"没有找到.当连接集合抛出此错误时未找到特定的连接元素.结束错误
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
错误:2012-08-09 00:21:06.25 代码:0xC00291EB 来源:执行 SQL任务 执行 SQL 任务描述:连接管理器《{DA7CD38D-F6AA-4B06-8014-58BEE5684364}》不存在.结束错误
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
错误:2012-08-09 00:21:06.25 代码:0xC0024107 来源:执行 SQL任务描述:任务验证期间出现错误.结尾错误 DTExec:包执行返回 DTSER_FAILURE (1).开始:00:21:04 完成:00:21:06 经过:1.888 秒.这包执行失败.步骤失败.
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 组件并指向连接管理器中的正确连接.
It seems that your ssis package is pointing to some other connection which might have been deleted or renamed .Try opening the SSIS compoenents and point to the correct connection which are there in your connection manager .
当我们复制 SSIS 包组件以创建新包或由于重命名连接或可能仍有组件使用 xml 配置文件中定义的旧连接时会发生这种情况(在您的情况下，请尝试检查 Execute SQL抛出错误的任务).如果您使用 XML 进行配置，请尝试部署新的.
It happens when we copy the SSIS package components to create a new package or because of renaming the connections or there may be still components which are using the old connection defined in you xml config file( In your case try checking the Execute SQL Task which is throwing error ) .If you are using XML for configuration try deploying the new one.
这篇关于在包中找不到 SSIS 连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
