Tuesday, January 08, 2008 4:26 PM
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".
Wednesday, January 09, 2008 3:19 AMModeratorYou might want to check the value of the variable that you are using - it sounds like the command is not valid. You can set a break point on the Execute Process task, and go to the locals window to see the value of the variable.
Wednesday, January 09, 2008 7:52 AMHi GBDB,
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.