Import from multiple flat files daily with filename and date

• aharish_iitk

  Newbie

  Points: 2

  More actions

  September 29, 2012 at 1:47 am

  #262379

  Dear 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 Awasthi

• aharish_iitk

  Newbie

  Points: 2

  More actions

  September 29, 2012 at 8:42 am

  #1543696

  I 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.

  Harish