[Connection manager "HTTP Connection Manager"] Error: SSL certificate response obtained from the server was not valid. Cannot process the request.

Question

Hello,

I am trying to download a file from ishare/sharepoint location.
am getting below error while trying.
[Connection manager "HTTP Connection Manager"] Error: SSL certificate response obtained from the server was not valid. Cannot process the request.
Please suggest

Thank You

Answer 1

Hi @Avis kumar ,

You can try to use WebClient Class instead of HTTP connection manager, someone fixed this issue, please refer to ssis-download-from-http-error-ssl-certification-response-obtained-from-server.

And here is a other solution: rewrite it as an SSIS Script Task with the help of the WSDL.exe Tool and then including the generated file (.cs) into your Script Task project. Or check the certificate you are using.

Please refer to https://stackoverflow.com/questions/31474244/visual-studio-bi-tool-error/51344042.

Hope it will help.

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