Hi ,

I create a package to unzip some files from specify folder. This package
is running fine if I execute manually. If I create a jobs under management in
the SQL Enterprise then it failed to execute. Below is the error log desc.
Please help

"PKUNZIP (R) FAST! Extract Utility Version 2.04g 02-01-93
Copr. 1989-1993 PKWARE Inc. All Rights Reserved. Shareware Version
PKUNZIP Reg. U.S. Pat. and Tm. Off.

þ 80486 CPU detected.
þ XMS version 2.00 detected.
þ DPMI version 0.90 detected.

PKUNZIP: (E09) can't find: c:/abc/*.ZIP
DTSRun: Loading...

DTSRun: Executing...

DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1

DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1

DTSRun OnStart: DTSStep_DTSCreateProcessTask_1

DTSRun OnError: DTSStep_DTSCreateProcessTask_1, Error = -2147220330
(80040496)

Error string: CreateProcessTask 'DTSTask_DTSCreateProcessTask_1':
Process returned code 9, which does not match the specified SuccessReturnCode
of 0.

Error source: Microsoft Data Transformation Services (DTS) Package

Help file: sqldts80.hlp

Help context: 1100
Error Detail Records:
Error: -2147220330 (80040496); Provider Error: 0 (0)

Error string: CreateProcessTask 'DTSTask_DTSCreateProcessTask_1':
Process returned code 9, which does not match the specified SuccessReturnCode
of 0.

Error source: Microsoft Data Transformation Services (DTS) Package

Help file: sqldts80.hlp

Help context: 1100
DTSRun OnFinish: DTSStep_DTSCreateProcessTask_1
DTSRun: Package execution complete.
"

--
Travis Tan

Remember when you execute a package manually the package will come to you
When you execute it as a job it executes at the server
It also executes perhaps under a different secutiry context

This article does a pretty good job of explaining the issues

http://support.microsoft.com/?kbid=269074

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Travis" <Travis (AT) discussions (DOT) microsoft.com> wrote