Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SSIS Web Service task SSL errors

Status
Not open for further replies.

how2trainyourdragon

Programmer
Dec 12, 2005
12
0
0
US
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
 
Not sure if makes a difference, but just told by db/server admin this web service is setup for cookie authentication.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top