Hello,
I have SQL server 7 SP4 running on Win2k SP3 and MDAC 2.6
(sp2 I guess)
I have recently run into problems with DTS Packages
scheduled to run some queries and then export tables to
text files.
The query step would run, but the export to text file step
will start exporting and then the package returns after
exporting some lines (6k out of 75k lines)
The text file will be locked until the sql server is
restarted. The problem doesnt appear when i run the
package interactively, but only when i schedule the
package to run as a job.
I appreciate your help in advance.
Michel Habib.

Could it be running out of disk space..?

When you run it interactivly the text file will be outputing to your disk
drive, when ran as a job it will be outputting to the server disk drive.

--
HTH
Ryan Waight, MCDBA, MCSE

"Michel Habib" <michel.habib (AT) utc (DOT) com> wrote

Not really, the server has over 50 GB of disk space, and I
used to run package interactively on the server itself.
The job however returns with a successful code right after
2 seconds (which is strange) knowing that it needs few
minutes to run and extract to file.

Thanks for your reply.
Michel.