none
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

     

    Tuesday, January 08, 2008 4:26 PM

Answers

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

     

    Wednesday, January 09, 2008 3:19 AM
    Moderator

All replies

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

     

    Wednesday, January 09, 2008 3:19 AM
    Moderator
  • 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


    Wednesday, January 09, 2008 7:52 AM