Execute Process Task to unzip in Foreach loop

Question

Hi,

 

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\

Variable:                   User::var_filename

keep getting error

 

The process exit code was "1" while the expected was "0".

Thanks

 

Answer 1

You 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.

 

Answer 2

Hi 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.

Thanks

Subhash Subramanyam