In a DTS package I am using TextFile as data source. I have specified the
source file as M:\XXX\xxx.dat. Where M is the mapped network drive. The same
package will not run when I schedule it. It says "Error opening datafile:
Access is denied".

Is it not possible to run successfully the scheduled DTS package when we
have a source file like this?

I am running SQL Server 2000.

Please advice.

Anil

In message <eL$veDJsEHA.1232 (AT) TK2MSFTNGP11 (DOT) phx.gbl>, Anil
<AnilGowda76 (AT) hotmail (DOT) com> writes
Mapped drives are specific to a users profile, so they are not really a
good thing to be using through a service. Change the path to use a UNC
path instead, e.g.

\\ServerName\ShareName\XXX\xxx.dat

You may also be having security problems as well, which applies to
either method. See-

INF: How to Run a DTS Package as a Scheduled Job
(http://support.microsoft.com/kb/q269074/)

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org