August 19, 2010 at 9:22 am
Hi,
I'm having the exact same problem. I have tried running wzunzip.exe via a script as well as the execute process. When running the script, the package states that it has completed, but no action has occur ed. When running through the execute process, I get :
Error: 0xC0029151 at Unzip Fixed Zip, Execute Process Task: In Executing "C:\Program Files\WinZip\WZUNZIP.EXE" "-o -ybc "D:\My Integration\Text Files\xxx_fa_20100816_01_00_45.zip" "D:\My Integration\Text Files\Fixed"" at "D:\My Integration\Text Files\Fixed", The process exit code was "-1073741819" while the expected was "0".
Task failed: Unzip Fixed Zip
where at "D:\My Integration\Text Files\Fixed" = Working Directory.
The arguments property is populated using expressions.
The app log error states : Faulting application WZUNZIP.EXE, version 0.0.0.0, time stamp 0x48c5c99a, faulting module wzcline.dll, version 24.0.8252.0, time stamp 0x48c5c9a3, exception code 0xc0000005, fault offset 0x0003c71e, process id 0x20f0, application start time 0x01cb3fa595081e16.
So it looks like a permissions issue. I'm operating on Windows Visita Business SP2. My SSIS Service is running under the Network Services account. I have tried running the service under my local account as well.
Do you think this is an UAC problem? I have tried providing all folders full access to the Network Services account (winzip and local folders), with no success.
Any help would be great. Have been working on this for 3 days now. All blogs pretty much state the same thing, which of all I have tried, with no success.
August 20, 2010 at 10:28 am
Well I got the Execute Process using wzunzip.exe to work under Vista. To accomplish this, I had to create a batch file to call the wzunzip.exe. I pass the exact same parameters as I did when calling the wzunzip.exe directly, so I assume that there is an authentication issue on Vista running the wzunzip.exe directly from the Execute Process task.
The batch file looks like:
%echo off
set param=%1 %2 %3 %4
Start "UnZip files" "C:\Program Files\WinZip\WZUNZIP.exe" %param%
set param=
where : %1 = "-o", %2 = "-ybc", %3 = Source File, %4 = Destination Folder.
Arguments property set via expression looks like:
"-o " + "-ybc " + "\"" + @[user::ZipFileName] + "\"" + " " + "\"" + @[user::WORKINGFOLDERUNZIP] + "\""
user::ZipFileName and user::WORKINGFOLDERUNZIP are populated in a ForEach and passed to the Execute Process Task so each variable will have a different source zip file name and destination folder name on each iteration of the loop.
So the only difference is changing the path of the "Executable" property to point to the batch file instead of calling "C:\Program Files\Winzip\wzunzip.exe" directly.
March 3, 2014 at 9:43 am
PERFECT!! THANK YOU!!
Viewing 3 posts - 31 through 32 (of 32 total)
You must be logged in to reply to this topic. Login to reply