I have a created a dts package (SQL2000) and schedued it to run every 15
minutes - 24 hours a day, 7 days a week. There have been a couple of times
the job has hung and not completed (almost once a day).

A quick description of the job follows:
1) Populate table2 with info from table1 for any record updated since the
last time the job ran.
2) Update table1 with a timestamp so that the records are not pulled the
next time.
3) FTP about 90 excel files from a template location to a standard directory.
4) Run about 90 queries against table2 to populate the copied excel files if
data meets the run criteria.
5) Email the excel file as an attachment to a distribution list if the file
was populated (ie. any records met the selection criteria).

I am using 1 global variable for each file to determine if the email should
be sent. Most of the time this entire process will complete in approx 30
seconds. There is not very much activity in table1.

What will cause this job to hang? Too many global variables? When it
hangs, I stop the job, restart it, and it completes fine with no error and
continues on schedule for a period of time.

Thanks in advance.