Steps of DTS package fails

• Melvin Mendez

  Newbie

  Points: 1

  More actions

  February 10, 2006 at 8:11 am

  #168234

  Hi!, i have a DTS package that invoques a SQL task in a remote server. 

  Sometimes one step of the package fails showing the next error message, the error appears randomly. Please note the error code showing below:

  Step Error Source: Microsoft OLE DB Provider for SQL Server

  Step Error Description:[DBNETLIB][ConnectionWrite (send()).]General network error. Check your network documentation.

  Step Error code: 80004005

  Step Error Help File:

  Step Error Help Context ID:0

  Any help will be received.

  Thanks.

• February 13, 2006 at 8:00 am

  This was removed by the editor as SPAM

• kevin mann

  Hall of Fame

  Points: 3894

  More actions

  February 15, 2006 at 12:35 pm

  #621171

  are you making a Windows or SQL Server Authentication Connection?

  are you using named pipes?

  are you using a DSN or DSN'less connection?

  you may want to Google "SQL Server 80004005"