BCP Failing

• SusanRoot

  SSC Enthusiast

  Points: 177

  More actions

  August 1, 2005 at 3:29 pm

  #88227

  We have a user attempting to BCP approx 8 million records into a SQL table via a job running on an Opalis job scheduler. The job is failing at differing stages with the following messages:

  SQLState = 01000, NativeError = 10054

  Warning = [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite (send()).

  SQLState = 08S01, NativeError = 11

  Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check your network documentation.

  SQLState = 08S01, NativeError = 0

  Error = [Microsoft][ODBC SQL Server Driver]Communication link failure

   

  Does anyone have an idea what might cause this type of problem?

   

   

  Thanks,

  Susan

• August 4, 2005 at 8:00 am

  This was removed by the editor as SPAM

• Sopheap Suy

  SSCertifiable

  Points: 7893

  More actions

  August 4, 2005 at 8:54 am

  #579612

  First of all I would tell them that they are not allow to bcp 8 million row into a database at a time.

  However they could try to work their code to slice the file into a smaller file and then you will help them find out why they are failing. 

   

  mom