BULK INSERT from a mapped drive

From: Marc (newsgroups_at_ris-nospam-web.net)
Date: 04/29/04


Date: Thu, 29 Apr 2004 20:04:09 +0200

Hi

I'm trying to BULK INSERT some data from a simple text file, residing on a
mapped drive (F:\)
Well, I know, it's better to use UNC-Paths, but it was "programmed" in that
manner some years ago. (Some dozens of stored procs which I don't want to
change)

This problem persists since we upgraded from NT/2000 to Server2003 (still
using SQL 2000):
while trying to bulk insert, I get an error, that the file can't be
found/accessed. (Path is correct)

MSDTC is configured running as a Domain-Account, and accessing the network
(COM-Configuration)
MSSQLSERVER-service is also configured as a Domain-Account.
Could this be a setting in Server2003 which I didn't found yet ???

Any help would be appreciated
Many thanks & regards,
Marc