Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 398
  • Last Modified:

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

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
sqlcurious
Asked:
sqlcurious
  • 3
  • 2
1 Solution
 
Bill PrewCommented:
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
 
Alpesh PatelAssistant ConsultantCommented:
You can get TaskUnZip from codeplex. It's great task to zip and unzip the folders/files with UI.

Zip Unzip
0
 
sqlcuriousAuthor Commented:
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
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
Bill PrewCommented:
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
 
sqlcuriousAuthor Commented:
the executable I was using was wrong, used the correct executable and it worked
C:\Program Files\7-Zip\7z.exe
0
 
sqlcuriousAuthor Commented:
thanks all
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now