SSIS Web Service task SSL errors

  • 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

    I'm Smithloo, working for web development company

  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • Sounds like your server doesn't trust the web service's SSL cert. Is the web service a self-signed cert or a cert signed by a non-public CA?

    If that isn't the case, you may need to manually add a trust to the web server's SSL cert.

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply