February 14, 2018 at 4:03 am
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
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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy