I have serveral DTS packages on an sql 2000 server used to import data from
text files downloaded from a mainframe database. The packages have been
running since November 2003 with no major problems until today. The
packages failed to run at the times scheduled (6 am Mon-Fri). When looking
at the scheduled times, they had been reset to 12:00 AM once a week. Any
reaon why would be aprreciated.

When you view the schedule through the package, it displays
the default times not the scheduled times.
To view the "real" schedule, you need to look at the job
that was created for the package..
See the following for more info:
BUG: DTS: Default Scheduling Information Displayed
http://support.microsoft.com/?id=221480

-Sue

On Tue, 13 Apr 2004 19:57:06 -0400, "Tom"
<bingoman (AT) stny (DOT) rr.com> wrote: