连接“连接"指的是“连接".找不到.验证连接管理器是否具有该名称的连接 [英] The connection "Connection" cannot be found. Verify that the connection manager has a connection with that name
问题描述
我在SSIS中使用ODATA连接管理器连接到私有的Sharepoint Online，当我创建连接管理器时，我设法测试连接，并在设计器中时预览列表.当我尝试在VS中执行程序包时，出现以下错误:
I'm using an ODATA connection manager in SSIS to connect to a private Sharepoint Online, I manage to test the connection when I create the connection manager and to do a preview of my list when I'm in the designer. When I try to execute the package in VS I'm getting the following error:
找不到连接连接".验证连接管理器是否具有该名称的连接
The connection "Connection" cannot be found. Verify that the connection manager has a connection with that name
OData源验证失败，返回了代码0xc020801A.
OData source failed validation and returned code 0xc020801A.
我已经创建了一个新程序包，并且我确定日志记录"选项卡中没有任何其他连接，而我的其他程序包(不使用OData连接mgr则工作正常)
I already created a new package and I'm sure that there is no any other connection in logging tab, btw my other packages (which dont use an OData connection mgr. works perfectly)
我的环境配置如下:
- VS Studio 2017社区版
- SQL Server数据工具15.1.61810.11040
- 在线Sharepoint
- 我还安装了"SharePoint Server 2013客户端组件SDK"，因为使用"SharePoint Online客户端组件SDK"，我什至无法在SSIS中配置连接管理器，因为出现以下错误:
无法加载文件或程序集"Microsoft.SharePoint.Client.Runtime"，版本= 15.0.0.0
Could not load file or assembly 'Microsoft.SharePoint.Client.Runtime', Version=15.0.0.0
在安装SDK 2013之后，我可以正确配置连接管理器.
After installing the SDK 2013 I could configure correctly the connection manager.
在此先感谢您的帮助.
推荐答案
谢谢您的回答.
我尝试重新创建新的解决方案，但收到了相同的错误消息:
I tried recreating a new solution but I got the same error message:
The connection "Connection" cannot be found. Verify that the connection manager has a connection with that name
OData source failed validation and returned code 0xc020801A.
如下图所示，在模式设计器中，我设法预览了共享点列表，但当我尝试执行程序包时出现了问题.
As you can see in the image here below, in mode designer I manage to make a preview of my sharepoint list, the problem comes when I try to execute my package.
这篇关于连接“连接"指的是“连接".找不到.验证连接管理器是否具有该名称的连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
