How to unzip a file in ssis?



How to unzip a file in ssis?..

Answer / Late Somaru Ram

In SSIS (SQL Server Integration Services), you can use the Script Task and call the Shell.Execute method to execute the command-line command for unzipping a file. For example, if your zipped file is named `myfile.zip` and it's located in the same folder as your project, you can use the following script: `System.Diagnostics.Process.Start("7za x " + Dts.Variables["User::ZipFile"].Value);`.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Database Management Interview Questions

Segregate database technology's development.

1 Answers  


Discuss some of the techniques that can be used to tune operational performance.

1 Answers  


What are the components of a database management system?

1 Answers  


What is trigger in dbms?

1 Answers  


What is building blocks of client/server?

1 Answers  


How do queries work in a database?

1 Answers  


What are the two major subsystems of system r?

1 Answers  


Can the User set Archive file name formats ?

1 Answers  


What are some of the important security features of a dbms?

1 Answers  


Is it possible to declare or create a cursor for update of table? If yes tell me how?

1 Answers  


Explain the scenarios or situations under which progress database creates new index entry for a record?

1 Answers  


How can we check whether A S M instance is up or down?

1 Answers   Excelacom, HCL,


Categories