BULK INSERT from a mapped drive
From: Marc (newsgroups_at_ris-nospam-web.net)
Date: 04/29/04
- Next message: Tibor Karaszi: "Re: BULK INSERT from a mapped drive"
- Previous message: Geoff N. Hiten: "Re: Advice on sa password change"
- Next in thread: Tibor Karaszi: "Re: BULK INSERT from a mapped drive"
- Reply: Tibor Karaszi: "Re: BULK INSERT from a mapped drive"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
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
- Next message: Tibor Karaszi: "Re: BULK INSERT from a mapped drive"
- Previous message: Geoff N. Hiten: "Re: Advice on sa password change"
- Next in thread: Tibor Karaszi: "Re: BULK INSERT from a mapped drive"
- Reply: Tibor Karaszi: "Re: BULK INSERT from a mapped drive"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]