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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-10-01 : 09:19:59
|
| Edy writes "HI, I would like to ask a question regarding my problem in BULK INSERT FROM. I am running my Query Analyzer in my workstation (lets call it PH-123) and connecting to a remote server (say PH-ABC). As I try to use "bulk insert from" to load a text data file into a table in PH-ABC. I encountered the following error.File C:\data.txt is unable to open. Operating system error.where C:\data.txt is residing in my workstation PH-123)I have tried to use UNC \\PH-123\data.txt, but the problem still exists. Is it something about the file access right for PH-ABC to the data file data.txt? Please advice. Thanks,Edy" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-10-01 : 09:58:42
|
| The path will be relative to the server so it would look for C:\data.txt on the server.\\PH-123\data.txtI take it PH-123 is your PC.Create a share on it put the file in the directory that is shared. Intially give everyone full control then\\PH-123\myshare\data.txt should work.You will need to give the bulk insert user (probably sql server service user) permissions on the directory ==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Bulk Insert From