Need to load Current TXT files into SQL SERVER2012

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2012 Forums

Analysis Server and Reporting Services (2012)

Need to load Current TXT files into SQL SERVER2012

Author

Topic

Arunraj
Starting Member

18 Posts

Posted - 2014-10-30 : 10:58:51

Hi frds,

I have fetched the TXT files through FTP from different location.All the file got loaded in my Local drive into single folder

And in that Folders i will have these kind of Files

ACTEST00001_20141028_0405_INV.TXT

ACTEST00001_20141029_0405_SL.TXT

ACTEST00001_20141028_0405_SV.TXT

ACTEST00001_20141029_0405_SV_APPT.

And i need to load these only ''20141029'' files only.

How can i do this in SSIS packege i need to skip rest all the files.

I have attached the Structure of my SSIS packege.

Please go through it and suggest me the solution please.
Hi frds,

I have fetched the TXT files through FTP from different location.All the file got loaded in my Local drive into single folder

And in that Folders i will have these kind of Files

ACTEST00001_20141028_0405_INV.TXT

ACTEST00001_20141029_0405_SL.TXT

ACTEST00001_20141028_0405_SV.TXT

ACTEST00001_20141029_0405_SV_APPT.

And i need to load these only ''20141029'' files only.

How can i do this in SSIS packege i need to skip rest all the files.

Please go through it and suggest me the solution please.

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2014-10-30 : 11:43:10

Your attachment didn't make it to the post.

In general though, you'd use a ForEachContainer with a For Each File iterator. Set the file mask to ACTEST00001_20141029*.txt. Process the files found in the body of the loop

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources