November 1, 2013 at 10:35 am
I am at a loss on what is going on with this. The commands are being run on the server, the files are on the D drive on the server. The first file loads, the second one fails with the following error message:
Msg 4860, Level 16, State 1, Line 2
Cannot bulk load. The file "D:\LF\ManualLoad\OBSERVED-102513.TXT" does not exist
I have tried copying the fully qualified path from the error message into notepad, file open dialog, on the server and the file does open from that path (nice confirmation that I am not hallucinating when I look in the windows explorer window and see the file, notepad also believes it does exist). I have also tried copying the file name from the error message and re-naming the file using that, but I still get the same error message.
BULK INSERT STGTBL_TEMPWEATHER FROM 'D:\LF\ManualLoad\OBSERVED-102413.TXT' WITH ( FIRSTROW = 2, FIELDTERMINATOR = '\t',ROWTERMINATOR = '')
BULK INSERT STGTBL_TEMPWEATHER FROM 'D:\LF\ManualLoad\OBSERVED-102513.TXT' WITH ( FIRSTROW = 2, FIELDTERMINATOR = '\t',ROWTERMINATOR = '')
Any suggestions?
November 1, 2013 at 10:47 am
Copied what should be the same files from another server, all worked.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply