且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

在包中找不到 SSIS 连接

更新时间:2023-02-03 21:27:44

您的 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.