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




Array

No comments yet... Be the first to leave a reply!