SSIS Web Service task SSL errors

Question

I've tried different credentials, target server versions, etc. hitting our Primavera WSDL.
Works great in any browser.

Via the Web Service SSIS task, I get an error when running the package:

** Target Server 2016:
--1. Connection manager "HTTP Connection Manager 1": SSL certificate response obtained from the server was not valid. Cannot process the request.

** Target Server 2019:
--2. 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

Answer 1

Hi @CC ,

Sounds like the SSL certificate on the server is not valid. This is probably because it's a temporary certificate, or you self-signed it.

Add the signer of the temporary certificate to the trusted authorities list on the computer running the package.

Or import the temporary certificate as a trusted certificate.

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

More details you may refer to:

using-a-script-task-in-sql-server-integration-services-ssis-to-connect-to-a-web-service

how-to-consume-web-service-through-ssis-package

Regards，

Zoe

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

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.

Answer 2

Not sure if makes a difference, but just told by db/server admin this web service is setup for cookie authentication.