Using Web Service and XML Tasks in SQL Server 2008 Integration Services
April 29, 2009[From SQL Server Performance]
SQL Server Integration Services (SSIS) is a Business Intelligence tool which can be used by database developers or administrators to perform Extract, Transform & Load (ETL) operations. In my previous article entitled Using the File System Task in SQL Server 2008 Integration Services I discussed how to use the File System Task which is available in SQL Server 2005 Integration Services and later versions. In this article I will examine the use of the Web Service and XML Tasks which are available in SQL Server 2005 and later versions.
The article continues at http://www.sql-server-performance.com/articles/biz/webservce_xml_tasks_ssis_p1.aspx