Scheduled Job with DTS Package Won't Stop

#1

I scheduled a DTS package to run nightly. For some reason, after the package
ran and did all it was supposed to do, it just hand there and did not stop. I
scheduled the same package on development server. It worked fine. What do I
need to check to find out what the problem is?

Thanks

Lisa

#2

I would use package logging and see if you can see on what task is
apparently hanging. Also make sure you set each task to "Close Connection
on completion"

Also make each task execute on the main package thread

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com

"Lisa Brown" <Lisa Brown (AT) discussions (DOT) microsoft.com> wrote

Quote:

I scheduled a DTS package to run nightly. For some reason, after the
package
ran and did all it was supposed to do, it just hand there and did not
stop. I
scheduled the same package on development server. It worked fine. What do
I
need to check to find out what the problem is?

Thanks

Lisa

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Scheduled Job with DTS Package Won't Stop

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Scheduled Job with DTS Package Won't Stop - 10-15-2004 , 04:21 PM

Re: Scheduled Job with DTS Package Won't Stop - 10-16-2004 , 03:26 AM