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.

Pages: 1 2 3




Related Articles :

  • No Related Articles Found

One Response to “Using Web Service and XML Tasks in SQL Server 2008 Integration Services”

  1. 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!

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |