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