OData源验证失败 [英] OData Source Failed Validation

问题描述

我正在使用SSIS 2016并在2016年SSIS目录中部署软件包。我们使用OData Source通过提供用户名/密码和Windows身份验证从SharePoint列表中获取数据。软件包在数据工具中正常运行，但是当我在SSIS
目录上部署它的连接验证失败时。

我尝试了以下选项。

• Run64Runtime为False
• 检查32位运行包时SSIS目录的运行时间。
• 更改保护级别并尝试不同的选项，例如存储密码在XML文件中。

下图可以很好地解释。

立即帮助将受到高度赞赏。

提前致谢。

解决方案

以下链接可以帮助您。

https://support.microsoft.com/en-us/help/918760/ssis-package-does-not-run-when-called-from-a-sql-server-agent-job-step

I am using SSIS 2016 and deploying packages at SSIS catalog 2016. We are using OData Source to get data from SharePoint list by giving both User Name/Password and windows Authentication. Package is working fine in Data Tools but when I deploy it on SSIS catalog its failed connection validation.

I have tried following options.

• Run64Runtime to False
• check 32 bit Run time at SSIS Catalog when I run the package.
• Change protection level and try different options e.g storing password in XML file.

Below Diagram will explain well.

immediate help would be highly appreciated.

Thanks in Advance.

解决方案

The below link could help you.

https://support.microsoft.com/en-us/help/918760/ssis-package-does-not-run-when-called-from-a-sql-server-agent-job-step

这篇关于OData源验证失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！