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.
| 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 |
 |
|
|
|
|
|
Need to load Current TXT files into SQL SERVER2012