Multi Thread Error running DTS Package in SQL 2005

• rmap07

  Grasshopper

  Points: 13

  More actions

  August 12, 2008 at 5:08 pm

  #196964

  Hi,

  I am running a DTS Package in SQL 2005. The package runs successfully on a single-thread. The DTS Package is executed as a SQL job and is scheduled every hour, daily. But once I configure the package to run on a multi-thread, it fails.

  I tried to do a multi-thread but run it only once, and it was successful. I scheduled the same job to run for 4 hours, and it was successful too.

  But when I schedule it to run straight for 1 day, it fails after 2 hours.

  What seems to be the cause for the job to fail on a multi-thread?

  Thanks.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 739344

  More actions

  August 17, 2008 at 6:40 pm

  #859215

  What's the error and what does the package do? Hard to say what the exact problem is.

  Also, if you post int he correct forum, you'll get more responses. (moved to DTS)