DTS Lockup. No errors

• joshcsmith13

  Hall of Fame

  Points: 3381

  More actions

  March 20, 2003 at 5:37 pm

  #105476

  I've got a Master Package that has 6 ExecutePackage tasks within it, each dependant on success of the previous before starting. Progress indicates that the first sub-package executed successfully. The second package just stops, 80% of the way through a series of DataPumps. I get a "... Progress count = 1000 ... Progress count = 2000 ..." on the command window and then all activity stops, without any indication of an error. The command window is still visible, as if the package is still running. oh yeah, btw, it's being run from DTSRUN command line.

  Any hypothesis on why it would just hang like that? I tried setting the Execute on Main thread property off the ExecutePackage tasks, but that didn't seem to make a difference.

• philcart

  SSC-Forever

  Points: 47797

  More actions

  March 20, 2003 at 6:16 pm

  #451643

  Are you running on SQL 2000? If so, turn on package logging and see if that gives you any info.

  Hope this helps

  Phill Carter

  --------------------

  Colt 45 - the original point and click interface

  --------------------
  Colt 45 - the original point and click interface