SQL Server 2005 SSIS

SQL 2005, My first Microsoft SQL Server 2005 Integration Services (SSIS) explore with this sample
1. This SSIS will loop each file in the folder, Extract sample data from the file
2. define Lookup transformation to obtain value of current key and time key
3. Write data to destination file.

Control flow


Data flow


This SSIS exercise and detail explanation can get from "Creating a Simple ETL Package Tutorial" in microsoft website
You also can get Hand on Training for SSIS from microsoft.