SSIS Web Service Task Error

Aparna 21 Reputation points


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,

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,451 questions
0 comments No comments
{count} votes

Accepted answer
  1. ZoeHui-MSFT 32,506 Reputation points

    Hi @Aparna ,

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

    More details you may refer:




    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

    0 comments No comments

0 additional answers

Sort by: Most helpful