Move the files from source to destination of specific period

Question

Hi Everyone,

I've few files which I want to move from one folder to another folder of specific period.(i.e. Around 1 month files are present in the source folder & want to move only last 15 days files in the destination folder)

Please provide the solution 

Cheers.................

Answer 1

How are you going to identify the files that need to be moved?   Name?  Last Modified Date? Created Date?

---

Chuck

Answer 2

Based on "Last modified Date"

Answer 3

I would just use a script task in the COntrol flow and do the entire operation in c#

---

Chuck

Answer 4

Something like this.  Add System.IO to your references and then create this function in the script task:  (untested but should be close - mostly sample code from the web)  You can get rid of a bunch of it if you don't want to look in subdirectories.

const int HowDeepToScan = 4;
        static DateTime Checkdate = DateTime.Now;

        public static void ProcessDir(string sourceDir, string destDir, int recursionLvl)
        {
            if (recursionLvl <= HowDeepToScan)
            {
                // Process the list of files found in the directory. 
                string[] fileEntries = Directory.GetFiles(sourceDir);
                foreach (string fileName in fileEntries)
                {
                    if (File.GetLastWriteTime(fileName).AddDays(15) < Checkdate)
                    {
                        File.Move(fileName, destDir);
                    }
   
                }
                

                // Recurse into subdirectories of this directory.
                string[] subdirEntries = Directory.GetDirectories(sourceDir);
                foreach (string subdir in subdirEntries)
                    // Do not iterate through reparse points
                    if ((File.GetAttributes(subdir) &
                         FileAttributes.ReparsePoint) !=
                             FileAttributes.ReparsePoint)

                        ProcessDir(subdir, destDir, recursionLvl + 1);
            }
        }

Then call the function from Main() in your script task, passing in the source and target directories (SSIS variables) and 0 for the recrsionLvl

---

Chuck