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.
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 AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
|
|