January 21, 2008 at 4:35 am
I am using Bulk Insert with a format file and I am getting the message that the file can not be read (as opposed to opened). I have had previous errors such as Invalid Column number (I have 244 columns in my input file) so the file is being read! When I have corrected those errors I now get the Msg 4862, Level 16, State 1, Line 1
Cannot bulk load because the file "C:\Documents and Settings\Chris\My Documents\EMac\Matrix Data\TDMFormatVehicle.Fmt" could not be read. Operating system error code (null).
If I add errors into the file I get the correct error messages (like column number wrong) - any help gratefully received.
January 21, 2008 at 5:37 am
I answered my own question. There was no return at the end of the last row!
December 6, 2010 at 1:28 pm
Confirmed this also worked for me when getting that error. Nice to know that BULK INSERT commands are dependent on whitespace...
February 2, 2011 at 8:31 am
AURGH!!!!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply