Solved

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

Posted on 2013-06-21
6
358 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 53

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
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 
LVL 53

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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Suggested Solutions

My client sends a request to me that they want me to load data, which will be returned by Web Service APIs, and do some transformation before importing to database. In this article, I will provide an approach to load data with Web Service Task and X…
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.
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

776 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