Solved

execute process task for 7zip to compress files not working properly

Posted on 2013-06-21
6
351 Views
Last Modified: 2016-02-11
in the General tab of the execute process task ->Process-> executable
I am having this "C:\Program Files\7Zip\7z920.exe"
and under the Process->Arguments I have the below:
a -tzip C:\Temp\test.Zip C:\Temp\test.csv

in the first place it prompts for an install window and then process the task after I hit execute, though it shows that it executed successfully I dont find the xip file in the directory

I tried haveing test.csv/test in the path above but doesn seem to work, please help
0
Comment
Question by:sqlcurious
  • 3
  • 2
6 Comments
 
LVL 51

Expert Comment

by:Bill Prew
ID: 39267044
I would say as a first test do the command on it's own in a DOS prompt window.  Open the command window, and do the following command line and see what it says, and if it creates the zip.

Also, you will need to use the -o command line option to place the created zip in a different folder than the working directory, so try this.

"C:\Program Files\7Zip\7z920.exe" a -tzip -oC:\Temp test.Zip C:\Temp\test.csv

Open in new window

(I'm assuming the file c:\temp\test.csv exists...)

~bp
0
 
LVL 21

Expert Comment

by:Alpesh Patel
ID: 39267557
You can get TaskUnZip from codeplex. It's great task to zip and unzip the folders/files with UI.

Zip Unzip
0
 

Author Comment

by:sqlcurious
ID: 39319195
Hi Billprew, the same thing happens when I do it through the DOS window, please suggest what to do
Hi PatelAlpesh, I am not able to add the task you suggested, do you have document which suggest the process to add the .dll file, thanks. I am following the below link but doesnt work:
http://agilebi.com/mcole/2009/08/18/adding-custom-components-to-ssis/
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
LVL 51

Expert Comment

by:Bill Prew
ID: 39319556
What was the exact commands you entered in the command prompt and what was display when you ran it, exactly as it appeared.

~bp
0
 

Accepted Solution

by:
sqlcurious earned 0 total points
ID: 39377841
the executable I was using was wrong, used the correct executable and it worked
C:\Program Files\7-Zip\7z.exe
0
 

Author Closing Comment

by:sqlcurious
ID: 39388579
thanks all
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Suggested Solutions

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

759 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now