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-05-16 : 10:21:34
|
| Faisal writes "Hi I am using bulk insert for loading data from text files to table, problem is when i put text files on local drive of sql server bulk insert works fine but when i put text files on network drive(mapped on sql server) it gave me error...message is :Server: Msg 4861, Level 16, State 1, Line 1Could not bulk insert because file 'f:\71508236450.txt' could not be opened. Operating system error code 5(Access is denied.).and one interesting thing is this whole scenario works in development but not in production......Can anybody help me out.Thanks a lot-Faisal." |
|
|
royv
Constraint Violating Yak Guru
455 Posts |
Posted - 2002-05-16 : 10:37:48
|
| Its a permissioning problem with the account that your sql server is running under. Make sure the account that sql server is running under has permissions to the file, or change the account that sql server is running under.*************************Someone done told you wrong! |
 |
|
|
joldham
Wiseass Yak Posting Master
300 Posts |
Posted - 2002-05-16 : 10:38:18
|
| Instead of using the Drive and Path, use the server name syntax. For example, instead of 'f:\71508236450.txt' use '\\Servername\71508236450.txt'. Try running it this way and if you still have problems, it is probaby a permission error on the server.Jeremy |
|
|
|
|
|
|
BULK Insert problem