public void Main()
{
string strFilePath = Dts.Variables["User::RootPath"].Value.ToString() + Dts.Variables["User::CurrentPath"].Value.ToString() + "\\" + Dts.Variables["User::CurrentDate"].Value.ToString() + "-" + Dts.Variables["User::CurrentPath"].Value.ToString() + ".xls";
//MessageBox.Show(strFilePath);
FileInfo file = new FileInfo(strFilePath);
if (file.Exists)
{
double fileSize = (double)file.Length / 1024;
//MessageBox.Show(fileSize.ToString());
//if file size <= 11k ,then delete
if (fileSize <= double.Parse(Dts.Variables["User::MinSize"].Value.ToString()))
{
file.Delete();
}
}
// TODO: Add your code here
Dts.TaskResult = (int)ScriptResults.Success;
}