SSRS Interview Question:

How to unzip a File in SSIS?

Submitted by: Administrator

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.
Submitted by: Administrator