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...