SSIS Web Service Task Error

Aparna 21 Reputation points
2021-04-30T01:51:27.157+00:00

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
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
1,843 questions
No comments
{count} votes

Accepted answer
  1. ZoeHui-MSFT 18,671 Reputation points Microsoft Employee
    2021-04-30T06:45:49.687+00:00

    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

    No comments

0 additional answers

Sort by: Most helpful