the number of failing rows exceeds the maximum specified [DBNETLIB][connectionWrite(send())]

  • Have a dts uploading data from a local sql server to a webserver. database names are the same, table names are the same too. When i run it from my local server it works fine with the webserver. when it is run from the actual production server i get the following error:

    "the number of failing rows exceeds the maximum specified [DBNETLIB][connectionWrite(send())]General Network error. Check your network documentation"

    any suggestions?

    Thanks

  • Could be a firewall issue.  I've had problems writing files to the DMZ.  I've had to change the process to write to a local drive and then copy to the destination.

    Dylan Peters
    SQL Server DBA

  • Thanks for the suggestion, I'look into it. In this case I have 4 other dts that work fine in the same conditions, except this one.

    Ray

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply