SQL Server Reporting Services Question:
Download Job Interview Questions and Answers PDF
How to unzip a File in SSIS?
Answer:
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.
► 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 Question | Next Question |
| Lookups are a key component in SQL Server Integration Services (SSIS). Explain its purpose? | Define Truncate and Delete commands? |