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
 SQL Server Development (2000)
 error on bulk insert

Author  Topic 

sqldba2k6
Posting Yak Master

176 Posts

Posted - 2007-05-09 : 14:09:08
I got the below error on executing the bulk insert..

Could not bulk insert because file 'mycomputername\\c:\test.txt' could not be opened. Operating system error code 123(The filename, directory name, or volume label syntax is incorrect.).


Executed Scripts:
bulk insert dbo.test from 'mycomputername\\c:\test.txt' with (FIELDTERMINATOR='|',ROWTERMINATOR = '')

Please correct me in above scripts...

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-05-09 : 14:55:50
As per my information, BULK INSERT requires UNC path for remote files. Is the path you specifying a valid UNC path? Shouldn't it be "mycomputername\\c$\\test.txt" ?

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"
Go to Top of Page
   

- Advertisement -