Solved

Cannot bulk load because the file was not found

Posted on 2013-11-12
7
1,991 Views
Last Modified: 2013-11-13
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?
0
Comment
Question by:Dovberman
  • 4
  • 3
7 Comments
 
LVL 6

Assisted Solution

by:SJCFL-Admin
SJCFL-Admin earned 500 total points
ID: 39642458
try

'\\Data\NASDAQ.txt'
0
 

Author Comment

by:Dovberman
ID: 39642907
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
 
LVL 6

Assisted Solution

by:SJCFL-Admin
SJCFL-Admin earned 500 total points
ID: 39643009
Did you give the account under which sql service is running permission to the share?
0
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 

Author Comment

by:Dovberman
ID: 39644648
I am not sure what you mean by giving the account.
0
 
LVL 6

Accepted Solution

by:
SJCFL-Admin earned 500 total points
ID: 39645630
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
 

Author Comment

by:Dovberman
ID: 39646861
The host tech support confirmed that I do not have permissions on a shared server.

Thanks for your help.
0
 

Author Closing Comment

by:Dovberman
ID: 39646862
The host tech support confirmed that I do not have permissions on a shared server.

Thanks for your help.
0

Featured Post

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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Syntax error with Dates where clause 10 49
sql server query 12 26
SQL Quer 4 22
Update one table with results from another table in SQL 6 27
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
I have a large data set and a SSIS package. How can I load this file in multi threading?
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question