January 30, 2007 at 11:03 am
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
February 2, 2007 at 8:00 am
This was removed by the editor as SPAM
September 16, 2008 at 12:22 pm
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\
May 7, 2021 at 11:29 am
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