DTS Package Not Running When Schedlued

I have been having a problem where I can not get a scheduled DTS pachkage t
o
run. It fails at all launch intervals. The Job can be launched manually and
it will import the data just fine. I am trying to import foxpro files into
the SQL server. Is this a permissions issue? What persmissions are passed
from SQL to the other server I am trying to import from?
Thanks
--
MitchTry granting permissions to the folder that contains the import FoxPro files
to the Windows account that the SQL Server and SQL Server Agent services are
starting under.
HTH
Jerry
"Mitchm" <Mitchm@.discussions.microsoft.com> wrote in message
news:4D64AB57-815C-4A91-87C2-9B5AFF3D26F5@.microsoft.com...
>I have been having a problem where I can not get a scheduled DTS pachkage
>to
> run. It fails at all launch intervals. The Job can be launched manually
> and
> it will import the data just fine. I am trying to import foxpro files into
> the SQL server. Is this a permissions issue? What persmissions are passed
> from SQL to the other server I am trying to import from?
> Thanks
> --
> Mitch|||Running from the scheduler, your DTS package is going to run under the
context of the user that SQL Agent is running under. Check the
properties of SQL Agent, see what user the service is running as. That
user needs to have access to the share that your Foxpro database is on.