How to get data from a Web Service that has HTTPS, SOAP and WSDL with an SSIS Project

Question

Gustavo Branco Goncalves 1

I need to get data from a Web Service that has HTTPS, SOAP and WSDL configuration.

Tried following this tutorial https://www.mssqltips.com/sqlservertip/3272/example-using-web-services-with-sql-server-integration-services/ , but stopped on the "Download WSDL file" step, because it gives me the error "Error initializing the HTTP session with the proxy “https://xxxxxx.xxx” This type of error can occur when na invalid proxy is specifyed. The HTTP Connection Manager supports only CERN proxies."

It looks like I can't use Web Service task if the web service has HTTPS...

I prefer to use Visual Studio 2015 in a SSIS project because i am going to store the information on a database later.

Thank you in advance!!!

Gustavo

Yitzhak Khabinsky 26,586 Reputation points

2020-08-28T15:11:01.597+00:00

You can try to use SSIS Script Task to call a Web Service.
Gustavo Branco Goncalves 1 Reputation point

2020-08-28T16:07:24.253+00:00

I would like to do that, but I do not know how... I've been days searching for just that, but couldn't find any instructions...
Yitzhak Khabinsky 26,586 Reputation points

2020-08-28T16:59:19.833+00:00

Please try the following link:
how-to-call-and-authenticate-pass-user-credentials-to-a-web-service-using-console-application-at-runtime-programmatically1
Gustavo Branco 1 Reputation point

2020-08-28T18:14:58.203+00:00

The web service I'm trying to gather information from is a SOAP and WSDL one, like this:

In Rubika's post the script just connects and gets data, this "wsdl soap" webservice doesn't give information after connecting to it, is shows XML tags like in the image.

1 answer

Yitzhak Khabinsky 26,586 Reputation points

2020-08-28T15:11:01.597+00:00

You can try to use SSIS Script Task to call a Web Service.
Gustavo Branco Goncalves 1 Reputation point

2020-08-28T16:07:24.253+00:00

I would like to do that, but I do not know how... I've been days searching for just that, but couldn't find any instructions...
Yitzhak Khabinsky 26,586 Reputation points

2020-08-28T16:59:19.833+00:00

Please try the following link:
how-to-call-and-authenticate-pass-user-credentials-to-a-web-service-using-console-application-at-runtime-programmatically1
Gustavo Branco 1 Reputation point

2020-08-28T18:14:58.203+00:00

The web service I'm trying to gather information from is a SOAP and WSDL one, like this:

In Rubika's post the script just connects and gets data, this "wsdl soap" webservice doesn't give information after connecting to it, is shows XML tags like in the image.

Answer 1

Monalv-MSFT 5,926

Hi Gustavo,

Hope the following links will be helpful:

Best Regards,
Mona

----------

If the response is helpful, please click "Accept Answer" and upvote it.