Import from multiple flat files daily with filename and date

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » Import from multiple flat files daily with...

Import from multiple flat files daily with filename and date

Rate Topic

Display Mode

Topic Options

Author

Message

aharish_iitk

Posted Saturday, September 29, 2012 1:47 AM

Forum 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

aharish_iitk

Posted Saturday, September 29, 2012 8:42 AM

Forum 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 »

Permissions