I am trying to use SSIS.Execute Process Task within Foreach loop . The task should unzip a a variable gzip file provided to it from the previous task
to execute the command from cmd C:\Program Files\GnuWin32\bin\gzip.exe -d -k c:\folder\filename
My input in the Execute Process Task as follow:
The command line: C:\Program Files\GnuWin32\bin\gzip.exe
Argument: -d -k c:\folder\
keep getting error
The process exit code was "1" while the expected was "0".
Try this, it should work without issues:
1) Double click Execute Process Task, Under Process option, insert C:\windows\cmd.exe for Executable field.
2) In the Expressions builder for Execute Process Task, In the Property list Chose Argument, In the Expression list Use the value => 'C:\Program Files\GnuWin32\bin\gzip.exe -d -k c:\folder\' + @[user::var_filename]
3) Validate it gives the right value.