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