question

Aviskumar-1057 avatar image
0 Votes"
Aviskumar-1057 asked ZoeHui-MSFT commented

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

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

windows-serversql-server-integration-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered ZoeHui-MSFT commented

Hi @Aviskumar-1057,

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


[2]: https://stackoverflow.com/questions/31474244/visual-studio-bi-tool-error/51344042

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

May I know how's the issue going on now?

0 Votes 0 ·