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.