April 6, 2012 at 1:09 pm
Hi All,
Task:Process text files
FolderName:Sales(Main Folder)
subfolders :name with datastamp like
04062012
04052012
----
---
---
04062011
04062011
---
---
04062010
04052010
Now I have to process txt files under sub folders
But here my problem is I have to process only 032011 (March 2011) to (March 2012)
[For one year data files]
Finally I have to select the 2011 and 2012 folders and process the txt files under which
I am thinking i have to capture the folder name and check the with condition
How to achieve this one in ssis
Thanks,
Mark
April 6, 2012 at 4:35 pm
You've got several concepts going on here that you need to learn before you can get all the way through the task. Here are a couple videos that cover some of what you need.
1. Looping Through and Loading Files with SSIS. What did you mean by "process" in your original post? If you're not planning to load the files to a database, ignore that part of the video. The first part of the video will show you how to setup a foreach loop to look at each file in a folder.
2. Learn how to write an expression, and use it to set the connection string of a file connection manager dynamically in SSIS: Adding a Time Stamp to a File Name in SSIS. This video will show you how to write an expression, and also covers looking at files using an expression.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply