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-07-10 : 09:01:36
|
| Alexis Piperides writes "I try to bulk insert a file that does not reside on the SQL server but on a machine connected to the server.I first try this:BULK INSERT xx_bond_category_temp FROM '\\netquest\d$\syndic\bonds\data\cat.txt' WITH ( CODEPAGE='ACP', FIELDTERMINATOR = ';', ROWTERMINATOR = '\n', MAXERRORS = 1 )I get the following error:Server: Msg 4861, Level 16, State 1, Line 1Could not bulk insert because file '\\netquest\d$\syndication\bonds\data\categories.txt' could not be opened. Operating system error code 5(error not found).The sql server machine has access to \\netquest\d$Since this did not work I created a mapping and I tried this:BULK INSERT xx_bond_category_temp FROM 's:\syndic\bonds\data\cat.txt' WITH ( CODEPAGE='ACP', FIELDTERMINATOR = ';', ROWTERMINATOR = '\n', MAXERRORS = 1 )I got the same error message.Do you know why this happens? Is there a workaround?Thanking you in advance!" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-07-10 : 10:06:42
|
| If the file does indeed exist, then it's probably a permissions issue. The account that SQL Server runs under may not have permissions to that drive. Check which account runs the MSSQLServer service and either give it the appropriate network rights, or change the account to one that already has rights. You should inform your network admin about this problem so that he/she is aware of the change. |
 |
|
|
|
|
|
BULK INSERT from network files problem