SSIS Web Service Task Error

Question

Hi,

I am trying to connect to a Web Service using SSIS Web Service Task and getting the following error -
(I could successfully download WSDL and can access the methods)

[Web Service Task] Error: An error occurred with the following error message: "Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebserviceTaskException:
The Web Service threw an error during method execution. The error is: The request was aborted: Could not create SSL/TLS secure channel..
at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebMethodInvokerProxy.InvokeMethod(DTSWebMethodInfo methodInfo, String serviceName, Object connection)
at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTaskUtil.Invoke(DTSWebMethodInfo methodInfo, String serviceName, Object connection,
VariableDispenser taskVariableDispenser)
at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTask.executeThread()".

But when I tried it using SOAP UI it works without any issue, I am able to get the response back from the Web Service.

Is there any SSIS setting or configurations that a required for SSL/TSL ?
I am using VS 2017, .Net Framework 4.8

Any help is much appreciated.

Thank you,
Aparna

Answer 1

Hi @Aparna ,

I think for webservices using SSL you may better off using Script Task rather than Webservice task.

More details you may refer:

consuming+web+services+in+ssis+script+task

Regards，

Zoe

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October