none
Loading .txt files daily from a different folder

    Question

  • Hey,

    I have a directory(Main), in that there is a folder (Sub), which has further subfolders (e.g. 20120101,20120202,20120303,20120404..etc). What I need to do is, get the .txt files from Date1,Date2,Date3,Date4..etc respectively and load them daily in to my SQL table. Is there any way to accomplish this? 

    E.g. The package that will run tomorrow morning (11/25/2012) will load the text file from yesterday (20121124). For my testing purposes, I want to load all the text files from these folders in my package.

    Sunday, November 25, 2012 1:16 AM

Answers

  • You would use a file system task after your data flow task and set the action to Move file

    Chuck Pedretti | Magenic – North Region | magenic.com

    • Marked as answer by Eileen Zhao Thursday, November 29, 2012 7:42 AM
    Sunday, November 25, 2012 2:02 PM

All replies

  • Just click the traverse subfolders checkbox in your for each file task.

    Chuck Pedretti | Magenic – North Region | magenic.com

    Sunday, November 25, 2012 1:44 AM
  • One more thing, i would like to add is: Once I have processed those files, I would like to add them to another folder (Archive). How can this be done?
    Sunday, November 25, 2012 3:04 AM
  • You would use a file system task after your data flow task and set the action to Move file

    Chuck Pedretti | Magenic – North Region | magenic.com

    • Marked as answer by Eileen Zhao Thursday, November 29, 2012 7:42 AM
    Sunday, November 25, 2012 2:02 PM