⟩ How to unzip a File in SSIS?
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.