Hi.



Running a batch job via DTS that calls an .exe. When I start it
manually within DTS it works, when its called from a job it gives the
following error:



Step Error Source: Microsoft Data Transformation Services (DTS) Package

Step Error Description:CreateProcessTask
'DTSTask_DTSCreateProcessTask_2': Process returned code 0, which does
not match the specified SuccessReturnCode of 1.

Step Error code: 80040496

Step Error Help File:sqldts80.hlp

Step Error Help Context ID:4900



The batch file runs no problem on its own, its only when its called via
a job or automatic process within DTS that it fails.



Any suggestions would be welcome


--
Posted via http://dbforums.com

In article <3484642.1066232927 (AT) dbforums (DOT) com>, rcmburton
<member44299 (AT) dbforums (DOT) com> writes









The most common issues with scheduled packages are around
permissions due to the execution context and the location of execution-

INF: How to Run a DTS Package as a Scheduled Job
http://support.microsoft.com/?kbid=269074

Support WebCast: Data Transformation Services Package Scheduling - An
Inside Look
http://support.microsoft.com/default...s/webcasts/wc1
02301/wcblurb102301.asp

I would also recommend you turn on logging within the package, either to
and error file or to a SQL Server (SQL 2000 Only) to get as much
information as possible.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org