Good Afternoon Everyone:

I have a DTS Package that completes successfully when executed on the
server as the SQL Service Account, but when it is scheduled it fails.
Here are the details:

Error Message:
DTSStep_DTSCreateProcessTask_1 DTSRun OnError:
DTSStep_DTSCreateProcessTask_1, Error = -2147220330 (80040496)
Error string: CreateProcessTask 'DTSTask_DTSCreateProcessTask_1':
Process returned code -1, which does not match the specified
SuccessRetu... Process Exit Code 1. The step failed.

Execute Process Task:
Execute process task calls a .bat file located at
\\ServerName\Share\task.bat. The .bat file calls another program and
passes some parameters ("C:\Program Files\IBM\QMF for
Windows\qmfwin.exe" /ISERVER:SERVERNAME /IPROCNAME:PROCNAME
/IUSERID:UserID /IPASSWORD:Password /batch). This connects to a DB2
database and runs a procedure that then opens a query and outputs a csv
file onto C:\Share\file.txt.

I have checked permissions on all folders and am using the UNC instead
of drive mappings. Any and all help is appreciated.

Regards,

Donna Robbins

Invariably when a package works OK at design time for the developer and
fails at runtime when scheduled it can be pinned down and fixed by reading
this article.

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


"Donna" <dzlvs2bike (AT) comcast (DOT) net> wrote