I was wondering if someone can shed some light on my dilemma. I have a SQL job that runs a script containing a bulk insert process.
Occasionally fails with the three error codes. 4832, 7399, and 7330.
Executed as user: xxxx . Bulk load: An unexpected end of file was encountered in the data file. [SQLSTATE 42000] (Error 4832) The OLE DB provider "BULK" for linked server "(null)" reported an error. The provider did not give any information about the error. [SQLSTATE 42000] (Error 7399) Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)". [SQLSTATE 42000] (Error 7330). The step failed.
The strange thing is that if I copy the script and run it in a query screen then it finishes just fine.
Does anyone know what may cause this?