SQL Server Reporting Services Question:
Download Questions PDF

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.

Download SSRS Interview Questions And Answers PDF

Previous QuestionNext Question
Lookups are a key component in SQL Server Integration Services (SSIS). Explain its purpose?Define Truncate and Delete commands?