Click here to Skip to main content
Click here to Skip to main content

Execute Process Task – Compress File Using 7-Zip

By , 13 Feb 2013
Rate this:
Please Sign up or sign in to vote.

Abstract

In this blog post I will demonstrate using SQL Server Integration Services' Execute Process Task to compress a CSV file into a zip format using 7-Zip.

Requirements

Article

Recently I have been involved in a project whereby I have been required to extract data into csv files, compress the files into a zip format and email the newly compressed files. This blog post is a first of several posts to come whereby I will be demonstrating how to fulfill such a requirement.

Let’s begin by launching Microsoft Visual Studio and create a new Integration Services Project which is located under Business Intelligence Projects category. (If you are using SQL Server 2012 or later, you will have to launch SQL Server Data Tools – SSDT).

After you have assigned a project name, proceed to click and drag the Execute Process Task (EPT) into Control Flow pane from toolbox (SSIS Toolbox in SSDT).

Right click EPT and click on “Edit”

Under the General Tab, you can assign relevant Name & Description. In this case I have decided to name the task as “EPT – Compress File” whilst Description remains unchanged.

In the Process Tab, the EPT properties must be set as follows:

  • RequiredFullFileName : True
  • Executable : C:\Program Files\7-Zip\7zG.exe
  • Arguments: a “SIFISO_Test.zip” “SIFISO_Test.csv
  • WorkingDirectory: C:\Test\Excel\20120930\
  • FailTaskIfReturnCodeIsNotSuccessValue: True
  • SuccessValue : 0
  • Timeout : 0
  • WindowStyle : Hidden

Basically what we have done above is, among other things, set the Executable property to the .exe location of the compression software we are using; set the Arguments such that file “SIFISO_Test.csv” is compressed into “SIFISO_Test.zip”; specified the working directory where the csv file will be located and zip file created; hid the exe window that appears when the file is being compressed.

It’s that simple.

Till next time folks, cheers.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

About the Author

Sifiso W Ndlovu
Software Developer select SIFISO
South Africa South Africa
No Biography provided
Follow on   Twitter

Comments and Discussions

 
-- There are no messages in this forum --
| Advertise | Privacy | Mobile
Web03 | 2.8.140421.2 | Last Updated 13 Feb 2013
Article Copyright 2013 by Sifiso W Ndlovu
Everything else Copyright © CodeProject, 1999-2014
Terms of Use
Layout: fixed | fluid