Web Service Task - Cannot reach any web services
Hello, I try to consume a web service in SSIS using the Web Service Task. Therfore I set up the HTTP Connection Manager with the Server URL, e.g. http://www.webservicex.net/stockquote.asmx and a proxy URL. But this dows not work. I get this error message: "The remote server returned an error: (404) Not Found." I can reach the URL http://www.webservicex.net, but not the web service itself. What am I missing here? Thanks
November 30th, 2011 10:47am

Possibly a firewall issue. You should try opening the URL (asmx) in IE (or SOAPUI is even better), if it does not then SSIS is not at fault.Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
November 30th, 2011 11:37am

Specify in HTTP Connection Manager: http://www.webservicex.net/stockquote.asmx?WSDL Download the WSDL in the Web Service Task and then you will be able to setup the method and its parameters.SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
November 30th, 2011 4:24pm

I can open the URL http://www.webservicex.net/stockquote.asmx with IE and Firefox using the same proxy settigns as for the HTTP Connection Manager...
Free Windows Admin Tool Kit Click here and download it now
December 1st, 2011 3:04am

I really would like to do that, but I cannot open neither http://www.webservicex.net/stockquote.asmx nor http://www.webservicex.net/stockquote.asmx?WSDL
December 1st, 2011 3:06am

I really would like to do that, but I cannot open neither http://www.webservicex.net/stockquote.asmx nor http://www.webservicex.net/stockquote.asmx?WSDL When you say you cannot reach the web service, does this happen during package execution like under SQL Job Agent or what ? When do you get the error you have described above ?SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
Free Windows Admin Tool Kit Click here and download it now
December 1st, 2011 8:27am

I get this error when setting up the HTTP Connection Manager. Since I cannot open th webservice I cannot download the WSDL file.
December 1st, 2011 11:16am

The link http://www.webservicex.net/stockquote.asmx?WSDL works for me. What error do you get 404? If so then like I said this is a firewall issue.Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
December 1st, 2011 11:22am

It works with me as well. Check your firewall.SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
December 1st, 2011 1:55pm

The link http://www.webservicex.net/stockquote.asmx?WSDL works for me. What error do you get 404? If so then like I said this is a firewall issue.Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
December 1st, 2011 6:54pm

The link http://www.webservicex.net/stockquote.asmx?WSDL works for me. What error do you get 404? If so then like I said this is a firewall issue.Arthur My Blog
December 1st, 2011 6:54pm

It works with me as well. Check your firewall.SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
Free Windows Admin Tool Kit Click here and download it now
December 1st, 2011 9:27pm

It works with me as well. Check your firewall.SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
December 1st, 2011 9:27pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics