dtsrun return codes

• kcanniff

  SSC Rookie

  Points: 33

  More actions

  June 19, 2002 at 2:13 pm

  #78329

  I need tp call dtsrun from the AutoSys scheduler, and I need to capture an integer return code (0 or some non-zero number) at the command line so that AutoSys knows whether to proceed to the next step. Is this possible. When you run the command on its own in a command shell window you get several lines of ouput, but it's not clear whether there is a single int return value.

  Thanks for any help

• Antares686

  SSC Guru

  Points: 125444

  More actions

  June 19, 2002 at 7:55 pm

  #431200

  I believe that in the command prompt you will see error: and the number and failed but not sure what line this will be on and it has been some time since I last did this. But I beleiev you will get multiple messages.

  "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

  Edited by - antares686 on 06/19/2002 7:56:03 PM

• crosspatch

  Hall of Fame

  Points: 3168

  More actions

  June 20, 2002 at 4:39 am

  #431218

  just a suggestion for the future. Try running calling DTS from a stored procedure as an automation object. This exposes a rich set of properties and methods which offer far more control over settings and error returns via the SP_OA family (see the articel on SQLDTS.COM)

  I have found it is possible to please all of the people all of the time if you do exactly what they want. Harold Macmillan 1961

  
  I have found it is possible to please all of the people all of the time if you do exactly what they want. Harold Macmillan 1961