How to unzip a File in SSIS?

Answer 1

The following is the process for Unzip a file in SSIS.

- Use Execute Process Task in the Control Flow Task.
- From BIDS, drag and drop an Execute Process Task to the control flow and configure.

In the Execute Process, perform the following configurations:

- Executable: The path of the application that is being used.
- Arguments: Need to supply the arguments to extract the zipped files. –o+ is the default parameter for overwriting files if they exist.
- Working Directory: The current directory for all process.