June 7, 2017 at 1:55 pm
hi
i am using execute sql task to zip my files to .gz extension.
but getting error :
executable : C:\program files\7z.exe
arguments : a "C:\Documents\Backup\filename.gz" "C:\Documents\Data\filename
I want to zip all files from data folder to back up,with .gz extension , how to do it
June 7, 2017 at 2:14 pm
coool_sweet - Wednesday, June 7, 2017 1:55 PMhii am using execute sql task to zip my files to .gz extension.
but getting error :
executable : C:\program files\7z.exe
arguments : a "C:\Documents\Backup\filename.gz" "C:\Documents\Data\filenameI want to zip all files from data folder to back up,with .gz extension , how to do it
I would have thought that you'd need to use the execute process task for this.
Can you make the command line work outside of SSIS?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
June 7, 2017 at 2:22 pm
sorry I m using execute process task but how can I get .gz extension here
June 7, 2017 at 3:11 pm
coool_sweet - Wednesday, June 7, 2017 2:22 PMsorry I m using execute process task but how can I get .gz extension here
I'll repeat my question. Can you make it work using a command line?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
June 7, 2017 at 5:50 pm
Heh... I hate people that send me .gz files and .rar files and all the rest. Just send me a good ol' fashion .zip file that works fine just about everywhere.
Also, I'm with Phil... make it work from the command line first. If you can't do that, then read the instructions for 7Zip and come back when you have it working from the command line.
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply