Wednesday, 10 June 2015

Scenario#1: Deleting a particular type of files from a location



Solution: Add SSIS Script Task. Write following code inside it

    public void Main()
        {
          string locZipFiles = Dts.Variables["zipFiles"].Value.ToString();
          DirectoryInfo di = new DirectoryInfo(locZipFiles);
          foreach (string file in Directory.GetFiles(locZipFiles))
          {
             //Will delete all files with .gz extension
              if (Path.GetExtension(file) == ".gz")
              {
                  File.Delete(file);
              }
          }
       }



Above code is deleting all files with extension gZ.

No comments:

Post a Comment