Search code examples
ssisetlunzipexecuteprocesstask

SSIS: Execute Process Task: How to unzip files in server without any softwares installed?


I need design a SSIS package to unzip files from a folder in Server.

The problem is there are no softwares like Winzip or Winrar installed on server.

Our IT dept doesn't installation of softwares on server so I am trying to figure out a way to do it.


Solution

  • .NET has the System.IO.Compression.ZipFile class to perform zip/unzip operations for the zip archive format. You could use a script task to unzip the file using ZipFile.