Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
drman
Starting Member
38 Posts |
 Posted - 2002-06-07 : 15:10:21
|
| Presently, I call a stored procedure that issues a bulk insert command from a local drive to import data into a temp table. It works quite well. I am now trying to issue the same command, but the file is located on a server. I map a directory to the location of the file, pull the file up in a rich text box in VB to verify the structure and then issue the Bulk insert command. SQL is returning an error message that the path is invalid. Below are some of the detailsDrive structure: SERVER1\Import\AccountNo\test.txtMap to L: SERVER1\Import L:\AccountNo\test.txtWhen calling the stored procedure in SQL, it informs me that the path is invalid. It seems to have a problem with the fact that the drive is L.Thanks in advance.Scott |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-06-07 : 15:43:11
|
| Mapped drives are notoriously tricky for SQL Server, you need to use the UNC path in order to guarantee that it works properly. |
 |
|
|
|
|
|
Bulk Insert from a file on mapped drive