Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2003
    Posts
    8

    Unanswered: problem with DTS package

    have a DTS package which utilizes an "Execute Process
    Task". This task calls a batch file on my server. I keep getting this error trying to run the DTS from sqlserver:

    "CreateProcessTask 'DTSTask_DTSCreateProcessTask_1': Process returned code -1, which does not match the specified SuccessReturnCode of 1:

    Does anyone know what this error mean? TIA

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    What is the level of service pack on SQL & OS?
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Feb 2004
    Location
    Hamburg, Germany
    Posts
    22
    Possibly the batch job you are calling is producing an error. Try executing your batch job from a command window and inspect its result.

    kbk

  4. #4
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Also enable DTS package logging for more information on this behaviour.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •