SQL Server Performance Forum – Threads Archive

Bulk Insert

Hi everyone,
here i am finding problem running bulk insert command
BULK INSERT Databasename..Table FROM ‘c:foldernamefilename.txt’ –WITH (TABLOCK)
error::
Msg 4861, Level 16, State 1, Line 1
Cannot bulk load because the file "c:FileImportPracticeExamImportFile.txt" could not be opened. Operating system error code 3(The system cannot find the path specified.).
Here Iam running this command on my local mechine and file also on same mechine. SRJ2005

---

Is SQL server locally installed?
If not then the path which you have specified is considered to be of SQL server so copy the file on SQL server and then try running it again.

---

The database installed on locally, It works,
before i stored the flat file on ‘c:folderfile’that didnot work .
on advise i just copied the same file on mssql folder this time works,may i know what is wrong/right. SRJ2005

---

May be other process on Operating system might have locked it when BULK INSERT is trying to access at the same time, as suggested make sure to check the permission for SQLAgent account if you have scheduld this as a job. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.

---

thank you SRJ2005

---

]]>