Re: Problem executing an Excute Process Task in DTS
From: Darren Green (darren.green_at_reply-to-newsgroup-sqldts.com)
Date: 03/16/04
- Next message: CQL User: "Re: DTS sp3 bug?"
- Previous message: Darren Green: "Re: Specified filename does not exist"
- In reply to: Lynne: "Problem executing an Excute Process Task in DTS"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 16 Mar 2004 17:32:53 +0000
In message <d70a01c40ac6$987b5b40$a501280a@phx.gbl>, Lynne
<anonymous@discussions.microsoft.com> writes
>I have a DTS package which utilizes an "Execute Process
>Task". This task calls a batch file on the server. I keep
>getting this message whenever I try to run the package:
>
>"CreateProcessTask 'DTSTask_DTSCreateProcessTask_1':
>Process returned code -1, which does not match the
>specified SuccessReturnCode of 1"
>
>Does anyone know what this error mean? How do I fix this
>error? TIA
I think the error what it says. There is an option on the task to
specify the return code which indicates success. Your batch file returns
-1, but the specified success value is 1, so it concludes that your task
has failed.
Find out what the batch file is doing and try and get some logging of
that process. Simple option may be to just pipe out the console, e.g.
myexe.exe > log.log
-- Darren Green (SQL Server MVP) DTS - http://www.sqldts.com PASS - the definitive, global community for SQL Server professionals http://www.sqlpass.org
- Next message: CQL User: "Re: DTS sp3 bug?"
- Previous message: Darren Green: "Re: Specified filename does not exist"
- In reply to: Lynne: "Problem executing an Excute Process Task in DTS"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
