question

Aparna-5862 avatar image
0 Votes"
Aparna-5862 asked ZoeHui-MSFT answered

SSIS Web Service Task Error

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


sql-server-integration-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered

Hi @Aparna-5862,

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




5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.