Error in Bulk Insert - SQL Server Forums

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 2000 Forums

Transact-SQL (2000)

Error in Bulk Insert

Author

Topic

karthickbabu
Posting Yak Master

151 Posts

Posted - 2008-12-10 : 01:21:25

BULK INSERT Table1 FROM 'E:\MyFolder\FileName.csv'
WITH ( FIELDTERMINATOR = ',', ROWTERMINATOR = '\n' )

Msg 4861, Level 16, State 1, Line 1
Could not bulk insert because file 'E:\MyFolder\FileName.csv' could not be opened.
Operating system error code 3(The system cannot find the path specified.).

File Path is correct.

what is the error?

====================================================
you realize you've made a mistake, take immediate steps to correct it.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-12-10 : 01:25:18

Is the file path correct from the database perspective, meaning that path and file exist on the database server and not on your client machine?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

karthickbabu
Posting Yak Master

151 Posts

Posted - 2008-12-10 : 01:48:57

Oops...I forget this one.

you are right. It my machine folder only.

Thanks

====================================================
you realize you've made a mistake, take immediate steps to correct it.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources