Generally, we are loading the file data from the source folder
and after file loaded we are doing archive these files in the archive folder. The business wants to delete the 60 days old files from the archive folder.
Let’s see in this demo how we will do.
Below is the archive folder.
Highlighted files are older than 60 days.
Taking Script task
Taking some variable
In script task we need to write C# code to delete the older
files.
|
string DirectoryPath = Dts.Variables["User::Archive_Folder"].Value.ToString();
int Number_of_day = (int)Dts.Variables["User::Number_of_day"].Value;
if (System.IO.Directory.Exists(DirectoryPath))
{
string[] files =
System.IO.Directory.GetFiles(DirectoryPath);
foreach (var file in files)
{
System.IO.FileInfo finf = new System.IO.FileInfo(file);
TimeSpan File_age = DateTime.Now.Subtract(finf.LastWriteTime);
if ((int)File_age.TotalDays >
Number_of_day)
//remove old file
System.IO.File.Delete(file);
}
}
|
Now package is ready to run.
Before running this package
After running the package.
See the archive folder
Get the expected result.
