Post reply

how to get detail error information using execute process task and handle exit code was “2” while the expected was “0”. in ssis

  • February 14, 2018 at 4:03 am

    #343603

    I have one doubt in ssis .how to zip to unzip files in ssis:

    I tried using execute process task in ssis:

    executable: C:\Program Files\7-Zip\7z.exe
    arguments: x "C:\zipfiles\texttables.zip" -o"C:\unzip\" -y
    then I executed package.its run successfuly for few days back.
    now I run the same package with out any changes in packages that time I am getting error like below:

    Error:In Executing "C:\Program Files\7-Zip\7z.exe" "x "C:\zipfiles\texttables.zip" -o"C:\unzip" -y" at "",
    The process exit code was "2" while the expected was "0".

    here what is the meaning of 2 and 0.it doesnot give detail error information. can you please tell me how to get detail error

  • February 14, 2018 at 4:29 am

    #1979703

    2 is a code that the application is returning to SSIS, in this case 7z.exe. Normally, when an application successfully completes it returns the code 0 (which, by default is what SSIS expects for the exit code). According to 7zip's documentation, Exit Code 2 means "Fatal Error".

    Generally, the easiest way to trouble shoot these execute process tasks, is to run the task as it would have done in a command window.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

Viewing 2 posts - 1 through 1 (of 1 total)

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