Posting Yak Master
Posted - 05/06/2013 : 12:21:50
I really appreciate if some one can guide me,
Here is the thing,
From one folder i am gonna read all .txt file and put in SQL Table. Once this done. Two steps.
1) Move all files in Archive and Rename it with a GETDATE() E.G file name was = text1.txt Rename it to = text1_05062013.txt
2) Once Transfer the data into SQL Table rename the same file in same folder to E.G file name was = text1.txt Rename it to = text1_05062013.txt
Here is my solution for.
1) For each Loop Container
2) Data Flow task inside For each Loop Container
3) File System Task.
I got first and second step, i am stuck in third step. Any help would be great appreciate....