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.

 All Forums
 SQL Server 2012 Forums
 SSIS and Import/Export (2012)
 Bulk load syntax

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 Message
Msg 4861, Level 16, State 1, Line 3
Cannot 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.
Go to Top of Page

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
Go to Top of Page
   

- Advertisement -