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 |
|
gripusa
Starting Member
3 Posts |
 Posted - 2007-11-23 : 05:38:34
|
| Hi Fellows! We are trying to import data from a textfile (residing over network PC B) on SQL Server (residing over PC C). Now when i connect to the Server (sitting on PC A) and try to run the Bulk Insert by loggin in Windows Auth. I got the error "Msg 4861, Level 16, State 1, Line 1Could not bulk insert because file '[PCBPath]\applicat.txt' could not be opened. Operating system error code 5(error not found)."Can you suggest me solution of this problem. |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2007-11-23 : 06:03:48
|
| This will be a permissions problem, make sure the user you are using has access to this file. |
 |
|
|
suresha_b
Yak Posting Veteran
82 Posts |
Posted - 2007-11-23 : 07:06:04
|
| Use UNC. For example: \\servername\sharename\applicat.txt |
|
|
|
|
|
|
Having Problems with Bulk Insert