Solved

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

Posted on 2013-06-21
6
355 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 52

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
[Webinar] Disaster Recovery and Cloud Management

Learn from Unigma and CloudBerry industry veterans which providers are best for certain use cases and how to lower cloud costs, how to grow your Managed Services practice in IaaS clouds, and how to utilize public cloud for Disaster Recovery

 
LVL 52

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
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…
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…

867 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

23 Experts available now in Live!

Get 1:1 Help Now