Bulk Insert 4832, 7399, and 7330 errors

• John Esraelo-498130

  SSCertifiable

  Points: 5916

  More actions

  August 2, 2021 at 3:50 pm

  #3916206

  Hello all,

  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?

  thx

  JohnE

   

  Cheers,
  John Esraelo

• Site Owners

  SSC Guru

  Points: 80325

  More actions

  August 3, 2021 at 4:10 pm

  #3916597

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• August 14, 2021 at 5:32 am

  This was removed by the editor as SPAM