Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Import from multiple flat files daily with filename and date Expand / Collapse
Author
Message
Posted Saturday, September 29, 2012 1:47 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, October 24, 2012 2:19 PM
Points: 2, Visits: 15
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


  Post Attachments 
DL290608I.zip (3 views, 2.18 MB)
Post #1366170
Posted Saturday, September 29, 2012 8:42 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, October 24, 2012 2:19 PM
Points: 2, Visits: 15
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
Post #1366194
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse