Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
na2173
Starting Member
38 Posts |
 Posted - 2002-10-01 : 16:59:39
|
| hi I have a SQL Server Agent job set up to run a job that calls a dts package on My local server DTS Package has only one step Execute process task which calls the batch program@ECHO OFFPkunzip A06.zip ren A06.xml A06.xmlcopy *.XML c:\xmlinbox\ del *.XMLdel A06.zipWhen I run the DTS Package manually, everything works fine and does what it is supposed to do. When I run the job, The job fails. If somebody had this error can you please help me outI am getting following error in my jobExecuted as user: Takro\nsem..mand, operable program or batch file. The system cannot find the file specified. *.XML The system cannot find the file specified. 0 file(s) copied. Could Not Find C:\Program Files\Common Files\System\Mapi\1033\NT\*.XML Could Not Find C:\Program Files\Common Files\System\Mapi\1033\NT\phx06.zipDTSRun: Loading... DTSRun: Executing... DTSRun OnStart: 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 SuccessReturnCode of 0. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 4900 Error Detail Records: Error: -2147220330 (80040496); Provider Error: 0 (0) Error string: CreateProcessTask 'DTSTask_DTSCreateProcessTask_1': Process ... Process Exit Code 1. The step failed. |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-10-01 : 18:18:28
|
| Use the full paths to the executables or issue dos SET commands to set then environment. DTS is a client side tool and so when you run it manually it can use your environment PATH options to locate the pkunzip executable. You can see its working folder is C:\Program Files\Common Files\System\Mapi\1033\NT\ which obviously is not what you want. Be as explicit as you can.HTHJasper Smith |
 |
|
|
|
|
|
Sql Agent error