Problem executing an Excute Process Task in DTS

From: Lynne (anonymous_at_discussions.microsoft.com)
Date: 03/15/04 

Date: Mon, 15 Mar 2004 11:49:15 -0800

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

Relevant Pages

  • Re: Problem executing an Excute Process Task in DTS
    ... >I have a DTS package which utilizes an "Execute Process ... This task calls a batch file on the server. ... >specified SuccessReturnCode of 1" ...
    (microsoft.public.sqlserver.dts)
  • Re: Execute a DOS batch file via a dts package..
    ... Add an "Execute Process" task to your package and specify the batch file in ... >I am trying to figure out how to run a simple dos batch file after a step ... > within a DTS package completes... ... > A DTS Package uses a FTP TASK to transfer a file. ...
    (microsoft.public.sqlserver.dts)
  • Execute Process Task catch return code
    ... I have a DTS package and it will call a .exe file in Execute Process ...
    (microsoft.public.sqlserver.dts)
  • Re: Error running DTS package on a schedule (only!)
    ... I use Remote Desktop to access the server where the DTS package was ... > Right Click on the SQL Server Agent icon in EM and choose properties. ... > page here will tell you the account. ...
    (microsoft.public.sqlserver.dts)
  • Re: Job Error. Need help ASAP.
    ... When you run a DTS package through EM you are ... If it can't connect to the server on the DMZ then have your ... connectivity by opening a dos window and telnetting to port 1433 on the DMZ ... This will tell you if the port is open. ...
    (microsoft.public.sqlserver.security)