|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Monday, August 03, 2009 10:13 AM
Points: 1,
Visits: 69
|
|
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.
|
|
|
|
|
SSChampion
Group: Administrators
Last Login: Today @ 8:37 AM
Points: 21,730,
Visits: 5,983
|
|
| 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)
|
|
|
|
