Cannot bulk load because the file was not found

Cannot bulk load because the file "//Data//NASDAQ.txt" could not be opened. Operating system error code 53(The network path was not found.).

NASDAQ.txt exists on the server.

BULK INSERT SymbolWork1 FROM '//Data//NASDAQ.txt'
WITH (      FIELDTERMINATOR = '\t',      ROWTERMINATOR = '\r' ,FIRSTROW = 1)

What do I need to change?
DovbermanAsked:
Who is Participating?
 
SJCFL-AdminConnect With a Mentor Commented:
you referenced file "\\Data\NASDAQ.txt"

That appeared to be a defined share name.  If you go to the folder level that you defined for the share and click on properties ; then Sharing; then Permissions; Under the Share Permissionos Tab you should include the account that sql server is being run under.  If not, SSMS would not have permission to access any files in the folder.

If this is not a share and 'Data' is the name of the Server and the NASDAQ.txt is on the C drive, then I would ahve expected the specification to look more like "\\Data\C$\NASDAQ.txt".  The service account that SSMS is running under would still be trying to access the file and would need permissions.
0
 
SJCFL-AdminConnect With a Mentor Commented:
try

'\\Data\NASDAQ.txt'
0
 
DovbermanAuthor Commented:
Tried
BULK INSERT SymbolWork1 FROM '\\Data\NASDAQ.txt'
WITH (      FIELDTERMINATOR = '\t',      ROWTERMINATOR = '\r' ,FIRSTROW = 1)

error:

Msg 4861, Level 16, State 1, Line 1
Cannot bulk load because the file "\\Data\NASDAQ.txt" could not be opened. Operating system error code 53(The network path was not found.).

Thanks anyway.
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
SJCFL-AdminConnect With a Mentor Commented:
Did you give the account under which sql service is running permission to the share?
0
 
DovbermanAuthor Commented:
I am not sure what you mean by giving the account.
0
 
DovbermanAuthor Commented:
The host tech support confirmed that I do not have permissions on a shared server.

Thanks for your help.
0
 
DovbermanAuthor Commented:
The host tech support confirmed that I do not have permissions on a shared server.

Thanks for your help.
0
All Courses

From novice to tech pro — start learning today.