If you notice Winzip return code 254, this guide might help.
Approved: Fortect
WinZip Command Line Support add-in return codes are not intended to provide specific information. Often, a return code can indicate several potential problems. For this reason, return codes are not propagated or verified. This directive is likely to remain in effect until specific information becomes available.
WZZIP and WZUNZIP in most cases return a non-zero error level in case of a serious error; otherwise, error level 0 is returned. Then you can simply use an IF or IF NOT statement with code returning 1 with batch files and other automatic processing, because it is essentially equal to or much greater than 1. The following example uses IF NOT.
Example: |
---|
wzzip -ez -rP filename.zip @ listfile.txt IF NOT ERROR LEVEL 1 FIND NEXT Replica error occured> error.txt PAUSE : NEXT |
In the above example, if no error occurs, ERRORLEVEL is “0” (ie NOT 1st or more), the batch file will probably continue executing the following commands: it is. However, when an error or error occurs, a .txt file is created and the task waits for a key stimulus (pause) before continuing with the command.For the channel you see, looking at your order in the log file is often the best way to determine the point at which your error occurs, and a new, severe error message is often raised. For more information, see How to Create a File Log Using the WinZip Command Line Support Add-in.
If you have any questions, please understand, submit a ticket to technical support.
You have questions? make more and more requests
We are using SQL Server 2008 R2, Winzip 15 with these special command line add-ins.
I created an option that has a percent taskThe message that Winzip will execute.
This package works well when saved to the server. Run
as a proxy account of the CEDAPPSRV Administrators group.
Run as user: ggg Proxy-Acct. Microsoft (R) Server sql Execute Package Utility Version 10.50.1600.1 64-bit (C) Copyright Notice Microsoft Corporation 2010. All rights reserved. Started: 14: 55: 51 2013-01-16 Error: 14: 55: 51.98 Code: 0xC0029151 Unzip Source: Write Source Data Execute Process Task Description: Run ” CEDAPPSRV D $ Program Files (x86) WinZip WZUNZIP.EXE “” -o -yb CEDAPPSRV D $ Zips Trade.ZIP “with” CEDAPPSRV D $ Zips “, the exit process code was” 254 “after waiting for” 0 “. DTExec completion error: package returned executing DTSER_FAILURE (1). Started: 14:55:51 Finished: 14:55:51 Elapsed: 0.265 seconds. Package execution failed. The technique failed.
I cannot connect to the server with the proxy account because it is controlled by the DBA.
Looks like an authorization problem; Are you suffering from your server admins wanting better permissions for this proxy account?
Problems automatically arises in the fact that WinZip must be installed high on the SQL server for the database.
It is currently installed on the application server and from there we run the SSIS package.
I submitted a WinZip SQL Agent job from the Application Server and received a message that I need a driver’s license to run a command line add-in.
Winzip (licensed version) and the command line add-in are installed on the application server, but neither on the database server nor on the database server.
Approved: Fortect
Fortect is the world's most popular and effective PC repair tool. It is trusted by millions of people to keep their systems running fast, smooth, and error-free. With its simple user interface and powerful scanning engine, Fortect quickly finds and fixes a broad range of Windows problems - from system instability and security issues to memory management and performance bottlenecks.
Ok, I’m playing, I also need to install Winzip as well as the command line add-on on the data server to be able to run it from the SQL Job Agent.
Speed up your computer's performance now with this simple download.