Using Web Service and XML Tasks in SQL Server 2008 Integration Services
14. Connect the Web Service tasks to the
XML Task as shown in the snippet below.
15. Finally to execute the package, right click the WebServiceTaskExample.dtsx package from the solution explorer and select the Execute Package option from the drop down list. Once the package has successfully executed you will be able to see the below screen within the control flow designer.
16. Once the package has successfully executed you will be able to see the updated files the C:StockQuote folder. Open StockQuote.XML to see the resulting XML from the StockQuote web service call. The Evaluate.txt file will have the value as true if the StockQuote.XML file is passing the schema validation.
Conclusion
In this article you have seen how to use Web Service Task and XML Task which is available in SQL Server 2005 Integration Services and later versions.
Thank you SO MUCH for posting this! I had been searching for several days on how to do this.
Two points:
1. In step 11, you have “StockQuoteStockQuote.XML” when it should be simply “StockQuote.XML” — and yes, the picture has the correct file name.
2. In step 12, when creating the StokeQuote.XSD file, readers should be careful with copying/pasting the XML code — I copied/pasted and it changed to be — not sure why, but it did, so create the file and then look it over again. I also re-did all the quote marks. You can open the .xsd file with your browser to make sure it opens properly — the first time I tried it gave me an error and I knew something was up with it.
Other than those tiny points, it was exactly what I wanted! Thanks so much!