Yes you should always use UNC vs mapped drives. You have to ensure the
account that will actually be used has permissions to this share. See this
for more details:
http://www.support.microsoft.com/?id=269074

--

Andrew J. Kelly
SQL Server MVP


"Ron Huffman" <dts (AT) dataspur (DOT) com> wrote

I am trying to import FoxPro tables from a NT4 server.

The DTS package fails during it's scheduled operation. It says it can't
find the FoxPro tables.

What appears to be happening is the FoxPro ODBC driver wants a mapped drive
to the table locations and the Schedule service doesn't have the mapped
drive.

Is there a way for the service to see mapped drives? or for the ODBC driver
to use an UNC path? (ie \\computername\path)




Import FoxPro table into SQL Server 2000