问题描述
我正在尝试使用 SSIS 中的 Web 服务任务调用 Web 服务.在 HTTP 连接管理器中我给出了服务器 URL,我没有定义任何代理服务器.我下载了 WSDL 文件.我在输入选项卡中选择了服务和方法.该方法需要一个我正在传递的字符串参数.我收到以下错误.我什至尝试将保护级别更改为 DontSaveSensitive,但仍然收到此错误.请帮忙
I'm trying to call a web service using the Web Service Task in SSIS. In the HTTP connection Manager I gave the Server URL, I haven't defined any proxy server. I downloaded the WSDL file. And I selected the Service and Method in the Input tab. The method expects a string parameter which I am passing through. I'm getting the following error. I even tried changing the Protection Level to DontSaveSensitive but still getting this error. Please help
Error: 0xC002F304 at Web Service Task, Web Service Task: An error
occurred with the following error message:
"Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebserviceTaskException:
Could not execute the Web method. The error is: Could not load file or
assembly 'Microsoft.SqlServer.WebServiceTask, Version=14.100.0.0,
Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its
dependencies. The system cannot find the file specified.at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTaskUtil.Invoke(DTSWebMethodInfo methodInfo, String serviceName, Object connection, VariableDispenser taskVariableDispenser)
at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTask.executeThread()".
推荐答案
在 Windows 8 中,程序集位于:C:\Windows\Microsoft.NET\assembly\GAC_MSIL
In windows 8 the assemblies are located at: C:\Windows\Microsoft.NET\assembly\GAC_MSIL
错误指出在 Microsoft.SqlServer.WebServiceTask 中找不到文件或程序集.它还说它正在寻找 Version=14.100.0.0 和 PublicKeyToken=89845dcd8080cc91.
The error states that it cannot find a file or assembly in Microsoft.SqlServer.WebServiceTask. And it also says that it is looking for Version=14.100.0.0 with PublicKeyToken=89845dcd8080cc91.
我进入了以下路径:C:\Windows\Microsoft.NET\assembly\GAC_MSIL\Microsoft.SqlServer.WebServiceTask
I went into the following path: C:\Windows\Microsoft.NET\assembly\GAC_MSIL\Microsoft.SqlServer.WebServiceTask
并且有 3 个文件夹,但没有一个在其名称中包含版本 14.所以我创建了一个名为v4.0_14.100.0.0__89845dcd8080cc91"的新文件夹
And there were 3 folders but none of them had a Version 14 in its name. So I created a new folder with the name "v4.0_14.100.0.0__89845dcd8080cc91"
我将复制的 Microsoft.SqlServer.WebServiceTask DLL 从 v4.0_13.0.0.0__89845dcd8080cc91 文件夹复制到新文件夹 (v4.0_14.100.0.0__89845dcd8080cc91).这对我有用.
And I the copied Microsoft.SqlServer.WebServiceTask DLL from the v4.0_13.0.0.0__89845dcd8080cc91 folder to the new folder (v4.0_14.100.0.0__89845dcd8080cc91). This worked for me.
这篇关于无法在 SSIS Web 服务任务中加载文件或程序集错误的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!