I am currently using SQL Server 2000 (sp3), I have created a DTS package
which imports data from a Unix server, this works fine when I execute the
package manually. The problem lies when I schedule the package to run
automatically, it runs the DTS package but returns no data in the imported
table.

You may want to have read of this article as it solves/explains a lot
of the issues around a scheuled package not being the same as an
intercative package.

Allan

"Suki Gill" <Suki Gill (AT) discussions (DOT) microsoft.com> wrote