DTS package

I'm using SQL 7.0 (but may have the same problem in SQL 2000). The
problem is: I created a DTS package to load data from a csv file. The
package works fine by manually start, but cannot be scheduled as a
job. As soon as it becomes a JOB, it doesn't work. Can anyone give me
an idea?
Thanks.

Saiyou"Saiyou Anh" <wangc@.alexian.net> wrote in message
news:a51d3ca7.0403020842.249335a@.posting.google.co m...
> I'm using SQL 7.0 (but may have the same problem in SQL 2000). The
> problem is: I created a DTS package to load data from a csv file. The
> package works fine by manually start, but cannot be scheduled as a
> job. As soon as it becomes a JOB, it doesn't work. Can anyone give me
> an idea?
> Thanks.
> Saiyou

http://support.microsoft.com/?kbid=269074

Simon