SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Problem with Web Service Task


Problem with Web Service Task

Author
Message
javierja16
javierja16
Grasshopper
Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)

Group: General Forum Members
Points: 10 Visits: 9
Hello.

I can't successfully create a web service in SQL Integration Services because the next error message appears when I try to enter the input properties of the Web Service Task:

"Could not read the Web Services Description Language (WSDL) file. The input WSDL file is not valid. The following error occurred while reading the file. There is an error in XML document (0, 0).."

Previously I created the HTTP Connection with the respective URL, user and password, tested the connection and downloaded the wsdl. I think that maybe the wsdl downloaded doesn't have the correct format but I don't know why it could be.

I hope you could help me.

Thanks.
Spiff
Spiff
Mr or Mrs. 500
Mr or Mrs. 500 (580 reputation)Mr or Mrs. 500 (580 reputation)Mr or Mrs. 500 (580 reputation)Mr or Mrs. 500 (580 reputation)Mr or Mrs. 500 (580 reputation)Mr or Mrs. 500 (580 reputation)Mr or Mrs. 500 (580 reputation)Mr or Mrs. 500 (580 reputation)

Group: General Forum Members
Points: 580 Visits: 2230
Hi Javierja,

Did you set up the HTTP connection correctly? You need to have the full address of the web service you wish to download the WSDL for in the URL.

e.g. http://<MyReportServer>/ReportServer/ReportService2010.asmx?WSDL

The WSDLFile property in the webservice task editor is path to save the file locally e.g. c:\rs.wsdl.
Richard Parsons-65
Richard Parsons-65
Valued Member
Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)

Group: General Forum Members
Points: 56 Visits: 73
I've had very much the same problem, and it's not about setting up the connection properly. When the wsdl file is downloaded (and I've found this with ALL book/online tutorials) there are tags missing. I found this through attempting to open the file in IE. When edited and all opening tags have corresponding closing tags, the error no longer happens. However, on the next stage of the tutorials when the Input tab is selected, there's nothing to select.

I've spent quite a long time looking into this, but can't find any resolutions that work. Quite disheartening really.
Spiff
Spiff
Mr or Mrs. 500
Mr or Mrs. 500 (580 reputation)Mr or Mrs. 500 (580 reputation)Mr or Mrs. 500 (580 reputation)Mr or Mrs. 500 (580 reputation)Mr or Mrs. 500 (580 reputation)Mr or Mrs. 500 (580 reputation)Mr or Mrs. 500 (580 reputation)Mr or Mrs. 500 (580 reputation)

Group: General Forum Members
Points: 580 Visits: 2230
Hi Richard,

I'd be more inclined to think there is a problem on your end rather then ALL the tutorials being wrong.

My point was that when setting up the connection you are in the HTTP connection manager rather then the Web Service Task and therefore testing the connection will suceed as long as a valid URL is entered. The HTTP connection manager is checking the HTTP connection and not whether you are pointing to is a valid webservice or WSDL file.

When you select "download WSDL" the task just downloads whatever is on the end of that URL into the filename specified, again it does not try to validate the WSDL. It is only when you try to list the webservices it finds the badly formed content and provides the error in the original post.

Check it by trying "http://www.google.co.uk" then try "http://wsf.cdyne.com/WeatherWS/Weather.asmx?WSDL"

It's far more likely you are doing something wrong or possibly the webservice you are connecting to is issuing badly a formed reply. Feel free to link the BOL tutorial if you want me to take a look and try to help.

Cheers.
Richard Parsons-65
Richard Parsons-65
Valued Member
Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)

Group: General Forum Members
Points: 56 Visits: 73
Thanks for your reply.

I've just connected to the webservice you mention (http://wsf.cdyne.com/WeatherWS/Weather.asmx?WSDL), clicked download, and still get the same error suggesting the xml is badly formed. I've been following the tutorials word for word, step by step and have tried three already. I agree that it seems unlikely they're all wrong, and the the common denominator is me. However, it's baffling.

I create a connection and successfully test it.
Create a string variable.
Drag the webservice task and so on......then the error.

Cheers,

Rich
Spiff
Spiff
Mr or Mrs. 500
Mr or Mrs. 500 (580 reputation)Mr or Mrs. 500 (580 reputation)Mr or Mrs. 500 (580 reputation)Mr or Mrs. 500 (580 reputation)Mr or Mrs. 500 (580 reputation)Mr or Mrs. 500 (580 reputation)Mr or Mrs. 500 (580 reputation)Mr or Mrs. 500 (580 reputation)

Group: General Forum Members
Points: 580 Visits: 2230
Did you definitely overwrite the existing file or choose a new file name?

I've attached the WSDL file I recieve. Could you attach yours?
Attachments
weath.zip (32 views, 1.00 KB)
Richard Parsons-65
Richard Parsons-65
Valued Member
Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)

Group: General Forum Members
Points: 56 Visits: 73
Yours works fine, so thanks for that. The files look completely different, so it may well be down to how the file is originally created?

here's mine:
Attachments
weather.rar (16 views, 1.00 KB)
Spiff
Spiff
Mr or Mrs. 500
Mr or Mrs. 500 (580 reputation)Mr or Mrs. 500 (580 reputation)Mr or Mrs. 500 (580 reputation)Mr or Mrs. 500 (580 reputation)Mr or Mrs. 500 (580 reputation)Mr or Mrs. 500 (580 reputation)Mr or Mrs. 500 (580 reputation)Mr or Mrs. 500 (580 reputation)

Group: General Forum Members
Points: 580 Visits: 2230
I get the same file as you if I dont append the "?WSDL" onto the end of the URL.

Can you confirm you definitely did this as the file you attached looks like the output of the webservice test page.

The URL should be exactly as follows: "http://wsf.cdyne.com/WeatherWS/Weather.asmx?WSDL".

You can visit either through your browser

http://wsf.cdyne.com/WeatherWS/Weather.asmx

then

http://wsf.cdyne.com/WeatherWS/Weather.asmx?WSDL

and you should see a difference, the first is the webservice test page the second should be the WSDL definition which looks like a XML file.

If you are not getting a difference I'm not sure what is going wrong.
Richard Parsons-65
Richard Parsons-65
Valued Member
Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)

Group: General Forum Members
Points: 56 Visits: 73
Strange one, indeed.

This is the URL I have in my http connection: http://wsf.cdyne.com/WeatherWS/Weather.asmx?WSDL:8080

The latter is just the proxy port.

Thanks for your help with this.
Spiff
Spiff
Mr or Mrs. 500
Mr or Mrs. 500 (580 reputation)Mr or Mrs. 500 (580 reputation)Mr or Mrs. 500 (580 reputation)Mr or Mrs. 500 (580 reputation)Mr or Mrs. 500 (580 reputation)Mr or Mrs. 500 (580 reputation)Mr or Mrs. 500 (580 reputation)Mr or Mrs. 500 (580 reputation)

Group: General Forum Members
Points: 580 Visits: 2230
Don't know much about how your proxy's work but shouldn't it be more like:

http://wsf.cdyne.com:8080/WeatherWS/Weather.asmx?WSDL

Otherwise I think it would be trying to the pass the ":8080" as part of the query in the URL which is why it defaults to the test screen.

Probably one to check with your network guys how to form the URLs so as to work with the proxy.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search