InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 13:51:03 GMT20http://www.sqlservercentral.com/Forums/Topic1366170-148-1.aspxI have been able to run ForEach loop for this problem. All the files loaded in a single run. It was amazing to see that.Now please help me with the location code and date extraction from the file name.Thanks in advance.HarishSat, 29 Sep 2012 08:42:52 GMTaharish_iitkhttp://www.sqlservercentral.com/Forums/Topic1366170-148-1.aspxDear All,I am a new comer to SQL Server and have no programming background. I am trying to make a database for my own small company.I get some 100 flat files everyday. All of them have same data format. I am attaching a zip of one day. I get one such zip file daily.The file name format is like I_location code_date.My requirement is that data from all these 100 files should be imported in a table into SQL Server 2005. Apart from the data from the files two new columns should be added for location code and date.I am trying to do this since last 10 days and I have put lot of efforts but could not do it. I have been successful in importing the data and the full file name. But I have not been able to capture date and location code. All this info is available in the file name. Also I want to do it in a single package but multiple flat file connector seems not to be working for me.I will be sincerely thankful for any help and solution in this regard.Harish AwasthiSat, 29 Sep 2012 01:47:00 GMTaharish_iitk