[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