且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

SSIS Web服务任务获取错误'从服务器获取的SSL证书响应无效。无法处理请求'

更新时间:2023-02-23 19:30:52

我们在Script Task中遇到了类似的问题,其中有逻辑下载文件。


在我们的例子中我们做的是使用Webclient类 基于逻辑而不是连接管理器来完成工作



类似下面的行


https://***.com/questions/ 43495703 / SSIS下载-从-HTTP-获得从 - 服务器错误的SSL认证响应


Hi

I am trying to add web service reference using Web Service task and the web service is having https protocol. after adding url in Http Connection manager i can successfully connect to server. I tried it using TestConnection but while loading WSDL getting an error 

TITLE: Web Service Task
------------------------------

SSL certificate response obtained from the server was not valid. Cannot process the request.


------------------------------
BUTTONS:

OK
------------------------------

Do i need to install any certificate?

We had similar issue faced in Script Task where there was logic downloading file.

In our case what we did was to use Webclient class  based logic instead of connection manager to get job done

Something like on the lines of below

https://***.com/questions/43495703/ssis-download-from-http-error-ssl-certification-response-obtained-from-server