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 |
Segregate database technology's development.
Discuss some of the techniques that can be used to tune operational performance.
What are the components of a database management system?
What is trigger in dbms?
What is building blocks of client/server?
How do queries work in a database?
What are the two major subsystems of system r?
Can the User set Archive file name formats ?
What are some of the important security features of a dbms?
Is it possible to declare or create a cursor for update of table? If yes tell me how?
Explain the scenarios or situations under which progress database creates new index entry for a record?
How can we check whether A S M instance is up or down?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)