Execute Process Task Error - The process exit code was "1" while the expected was "0".

  •  How do I use the execute process task?  I am trying to unzip the file using the freeware PZUnzip.exe and I tried to place the entire command in a batch file and specified the working directory as the location of the batch file, but the task fails with the error:

    SSIS package "IngramWeeklyPOS.dtsx" starting.

    Error: 0xC0029151 at Unzip download file, Execute Process Task: In Executing "C:\ETL\POSData\IngramWeekly\Unzip.bat" "" at "C:\ETL\POSData\IngramWeekly", The process exit code was "1" while the expected was "0".

    Task failed: Unzip download file

    SSIS package "IngramWeeklyPOS.dtsx" finished: Success.

    Then I tried to specify the exe directly in the Executable property and the agruments as the location of the zip file and the directory to unzip the files in, but this time it fails with the following message:

    SSIS package "IngramWeeklyPOS.dtsx" starting.

    Error: 0xC002F304 at Unzip download file, Execute Process Task: An error occurred with the following error message: "%1 is not a valid Win32 application".

    Task failed: Unzip download file

    SSIS package "IngramWeeklyPOS.dtsx" finished: Success.

    The command in the batch file when run from the command line works perfectly and unzips the file, so there is absolutely no problem with the command, I believe it is just the set up of the variables on the execute process task editor under Process.  Any input on resolving this will be much appreciated.

    Thanks,

    Monisha

  • This was removed by the editor as SPAM

  • Follow this link: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=97685

    It has the solution to your issue.

    Executable: C:\Program Files\Winzip\WINZIP32.EXE

    Arguments: -e -o C:\temp\File.zip

    WorkingDirectory: C:\temp\

  • Execute Process Task Error - The process exit code was "1" while the expected was "0". in Linux  using dot net core

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply