I need to extract data from .CSV files and load into SQL database Table using SSIS 2008 or 2005. For examples 1) Project120110117_1.CSV 2) Project120110117_2.CSV 3) Project120110117_3.CSV 4) Project120110117_4.CSV 5) Project120110117_5.CSV I have 5 files with the same name but different data stamp. I have to Load the .CSV files data into SQL database table. Can any suggest me , what's the best way to do this. Note: All the .CSV files have same column names but will have different data.Any help much appriciated. Thanks Dasari

Hello Dasari, This can be done with a DFT inside a ForEach Loop. Example: this http://www.kodyaz.com/articles/import-csv-flat-file-into-sql-server-using-ssis-integration-services.aspx in http://www.sqlis.com/post/Looping-over-files-with-the-Foreach-Loop.aspx Arthur My Blog

Thanks Mate. It's working :).Dasari