Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2013-06-21
6
Medium Priority
?
390 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 59

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
Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

 
LVL 59

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

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

My client has a dictionary table. They're defining a list of standard naming convention. Now, they are requiring my team to provide us a mechanism how to match new incoming data with existing data in their system.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…

971 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