January 17, 2013 at 8:13 am
We are using SQL Server 2008 R2, Winzip 15 with the command line addons.
I have created a package which has a Process Task running Winzip.
The executable line is defined as \\CEDAPPSRV\D$\Program Files (x86)\WinZip\WZUNZIP.EXE
The arguments line is defined as -o -yb \\CEDAPPSRV\D$\Zips\Trade.ZIP \\CEDAPPSRV\D$\Zips\
This package runs fine when I am logged into the server.
I have scheduled this SSIS package in SQL Server Agent.
It runs as a Proxy account which is in the CEDAPPSRV Administrations group.
The package source is defined as File system.
When I run the job, I get the following error:
Executed as user: ggg\Proxy-Acct. Microsoft (R) SQL Server Execute Package Utility Version 10.50.1600.1 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 2:55:51 PM Error: 2013-01-16 14:55:51.98 Code: 0xC0029151 Source: Unzip Source file Execute Process Task Description: In Executing "\\CEDAPPSRV\D$\Program Files (x86)\WinZip\WZUNZIP.EXE" "-o -yb \\CEDAPPSRV\D$\Zips\Trade.ZIP" at "\\CEDAPPSRV\D$\Zips\", The process exit code was "254" while the expected was "0". End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 2:55:51 PM Finished: 2:55:51 PM Elapsed: 0.265 seconds. The package execution failed. The step failed.
Any suggestions?
I can't log into the server as account Proxy-Acct since it is controlled by the DBA's.
January 17, 2013 at 9:48 am
Sounds like a permissions issue; can you work with your server admins to get the correct permissions assigned to that proxy account?
Rob
January 17, 2013 at 10:49 am
The issue appears to be that WinZip needs to be installed on the Database SQL server.
We currently have it installed on an App server and run the SSIS package from there.
I sent up a SQL Agent job which runs WinZip from the Apps server and I get a message that I need a license to run the Command line addon.
Winzip (licensed version) and the command line addon are both installed on the Apps server but neither on the Database server.
So, I guess I also have to install Winzip and the Command line addon on the database server to be able to run it from SQL Agent job.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply