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 |
|
sportsguy
Starting Member
39 Posts |
 Posted - 2014-11-12 : 12:29:36
|
| Getting an error message. . [Code]BULK INSERT dbo.tmp_SALESREP FROM '\\uswmi1lt00656\Users\myname\DATA\TXT_DOWNLOADS\SALESREPS.txt' WITH (FIRSTROW = 2,FIELDTERMINATOR = '|',ROWTERMINATOR = '\n')GO[/code]Error MessageMsg 4861, Level 16, State 1, Line 3Cannot bulk load because the file "\\uswmi1lt00656\Users\myname\DATA\TXT_DOWNLOADS\SALESREPS.txt" could not be opened. Operating system error code 67(The network name cannot be found.).MS Access 20 years, SQL hack |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-11-12 : 12:31:58
|
| Can SQL Server (not you) access that network share? Recall that SQL Server runs under its own account. That account needs to be able to access the share that holds your file. |
 |
|
|
Andre1802
Starting Member
4 Posts |
Posted - 2014-11-20 : 05:55:03
|
| As far as I know SQL cannot access network drives, same is true for database restores from network drives |
|
|
|
|
|
|
Bulk load syntax