First of all the path should be as Ilya explained in windows path format i.e C:\Files\FileName.CSV and you are also missing the ROWTERMINATOR clause of your bulk insert. –M.Ali Jun 5 What to do when majority of the students do not bother to do peer grading assignment? Dan Guzman SQL Server MVP "Loi Tan Vo"
Now I'm getting this message: Line 1: Incorrect syntax near ','. this however seems also to indicate that you have named pipes enabled on the server ... Yes!!! If this is the case you can still use the UNC Path \\ServerName\Folder\FileName.CSV , Just make use Your login has permissions on that Network Share.
if yes: that is the problem Go to Solution 26 Comments LVL 4 Overall: Level 4 MS SQL Server 2005 2 MS SQL Server 2 Message Expert Comment by:anandarajpandian2011-06-22 please Evidently it was the username asp.net was using to open the command with. Thank you, Doug Moved by Tom PhillipsModerator Saturday, May 08, 2010 1:49 AM TSQL question (From:SQL Server Database Engine) Friday, May 07, 2010 4:50 PM Reply | Quote Answers 2 Sign Cannot Bulk Load Because The File Does Not Exist I can also open the file from the SQL server.Anyone have any idea what causes this?
You cannot post events. Operating System Error Code 21 Are you doing that on computer where both sql server and file exists? Random noise based on seed Why does Deep Space Nine spin? share|improve this answer answered Oct 21 '13 at 13:07 acfrancis 2,2191015 How do I configure the SQL job to run as your own username?
The file path is relative to the server, not your PC. http://dba.stackexchange.com/questions/66637/operating-system-error-code-3failed-to-retrieve-text-for-this-error-reason-15 Operating system error code 5 (Access is denied.)1Operating system error code 5(Access is denied.) when bulk insert0Cannot bulk load Operating system error code 5(Access is denied.)0Sql Server Agent job failing to Cannot Bulk Load Because The File Could Not Be Opened. Operating System Error Code 3 But when I put the data in a sql server situated not locally, then I get a error message like this: Could not bulk insert because file 'C:\Data\2003 txtfiles\abif_20031130.txt' could not Operating System Error Code 3(failed To Retrieve Text For This Error. Reason: 15105) asked 2 years ago viewed 24211 times active 1 year ago Related 7SQL Server CREATE FILE encountered operating system error 5 (Access is denied.)3Login failed for user Error: 18456 State: 105SQL
You cannot edit your own events. if it runs under the default "localsystem", it won't have access to that file indeed. 0 Message Author Comment by:dev_intagleo2011-06-22 I think em getting a bit closer now. Cannot find file specified Error 2465 "Access cannot find the field..." Cannot find file specified error error: Specified driver could not be loaded due to system error 1 Browse more Microsoft More about the author When the SQL server is in local machin, it works well.
Operating system error code 3(The system cannot find the path specified.). xp_fileexist throws the same error. –user3455309 Jun 5 '14 at 9:45 add a comment| up vote 0 down vote Looks like the service account which you are you using in the You cannot post new polls. Bulk Load: An Unexpected End Of File Was Encountered In The Data File Get 1:1 Help Now Advertise Here Enjoyed your answer?
You cannot edit your own posts. I use SSIS instead. You cannot edit HTML code. click site Hope that helps you, Joe J 0 Message Author Comment by:dev_intagleo2011-06-22 Phew!!!!!!