Using The File System Task in SQL Server 2008 Integration Services
March 25, 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 Container Tasks in SQL Server 2008 Integration Services I discussed the different types of container tasks such as For Loop Container, Foreach Loop Container, Task Host and Sequence Container and how they can be used by database developers. In this article I will examine the use of the File System Task which is available in SQL Server 2005 and later versions of Integration Services.
The article continues at http://www.sql-server-performance.com/articles/biz/file_system_task_ssis_p1.aspx