Post reply

Scheduled DTS failed due network failure....

  • July 24, 2006 at 7:22 pm

    #61463

    Please HELP!!!!!

    I have a DTS package that is scheduled to run daily, it reads and uploads the files on the same server, the problem is, is that it fails whenever a network failure occurs. I was just wondering that how could it fail when the script and the files to be uploaded are on the same server.

    Thanks in advance.

     

  • July 24, 2006 at 9:04 pm

    #651238

    What do the job history and dts logs say? If the job is owned by an integrated security account, it may be failing to authenticate against the domain. If so, change the owner to a standard security account.

  • July 25, 2006 at 12:52 am

    #651258

    here's the exact error message on the package logs:

    Step Error Source: Microsoft Data Transformation Services (DTS) Package

    Step Error Description:Error Code: 0

    Error Source= Microsoft OLE DB Provider for SQL Server

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

    Error on Line 45

     (Microsoft OLE DB Provider for SQL Server (80004005): [DBNETLIB][ConnectionWrite (send()).]General network error. Check your network documentation.)

    Step Error code: 800403FE

    Step Error Help File:sqldts80.hlp

    Step Error Help Context ID:4500

    Line 45 contains an insert statement which inserts data in a table on the same server.

    the job is owned by an administrator account.

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

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