The device is not ready.).

Last Post 18 Jun 2004 01:03 PM by mimadon. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
bryanmurtha
New Member
New Member

--
18 Jun 2004 08:59 AM
1, Server DB0, Line 1
Could not bulk insert because file
'd:\dbTransferFiles\fmt\RouteConfiguration.fmt' could not be opened. Operating
system error code 21(The device is not ready.). This is wierd, it might be a drive problem, I'm thinking but I looked under disk administrator and they look healthy. What I'm doing is a bcp out of a different database on the local disk, truncate the local table drop the indexes, bulk insert the table and reapply the indexes. It fails at the bulk insert with the above error. However I am able to do the same thing with a much larger table with no problems. I googled and didn't find anything like this problem or in BOL. Maybe it's a permissions thing, I have to look into it further but was just hoping someone could look at this and say this is your problem...

Regards,
Bryan
mimadon
New Member
New Member

--
18 Jun 2004 01:03 PM
Remember that:

If you're using BCP.EXE then the file paths are from the perspective of the client machine running the BCP.EXE.

If you're using BULK INSERT then the file paths are from the perspective of the machine running the SQL Server service.


Acceptable Use Policy
---