Explain the way to unzip a File in SSIS

Question

Explain the way to unzip a File in SSIS.

Answer 1

The given is the process for Unzip a file in SSIS (SQL Server Integration Services) as follows:

• Utilize Execute Process Task within the Control Flow Task.
• From BIDS, drop and drag an Execute Process Task to the control configure and flow.

While the Execute Process, perform the given configurations as follows:

• Executable: It is the path of the application which is being used.
• Arguments: require to supply the arguments to extract that zipped files. There –o+ is the default parameter for overwriting files when they exist.
• Working Directory: It is the current directory for all process.