Re: Problem with nightly runs
From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 10/18/04
- Next message: Randall: "New transaction cannot enlist in the specified transaction coordinator"
- Previous message: Andrew Gale: "overwrite existing record"
- In reply to: OV: "Re: Problem with nightly runs"
- Next in thread: Sue Hoegemeier: "Re: Problem with nightly runs"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 18 Oct 2004 14:14:40 -0400
Well unfortunately that is not enough info to go on. You might want to run
some traces to see what else may be happening.
-- Andrew J. Kelly SQL MVP "OV" <gnews84@hotmail.com> wrote in message news:a03f6b0d.0410180610.38bb82fc@posting.google.com... > That is what I thought, but sometimes the step that fails is > rebuilding aggregate tables within the same server where the DTS > package is being run. > > "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message > news:<eh$LYgysEHA.272@TK2MSFTNGP12.phx.gbl>... >> Sounds to me just like it says and that it is network related. >> Especially >> if it happens at differnt places and times. I would check your network. >> >> -- >> Andrew J. Kelly SQL MVP >> >> >> "OV" <gnews84@hotmail.com> wrote in message >> news:a03f6b0d.0410151620.74cb54e0@posting.google.com... >> > Hi Everybody, >> > >> > I am having problems with a DTS package that runs nightly. It is >> > always the same error but it happens at different steps of the process >> > and at different times. It happens on average of once or twice a week. >> > The rest of the time it runs fine. Some of the steps where it has >> > failed are simply rebuilding tables within the database and have >> > nothing to do with the network. We are on SQL server 7.0 >> > The error that I get is: >> > >> > Step Error Description:Unspecified error >> > (Microsoft OLE DB Provider for SQL Server (80004005): >> > [DBNETLIB][ConnectionRead (recv()).]General network error. Check your >> > network documentation.) >> > Step Error code: 80074005 >> > Step Error Help File:sqldts.hlp >> > Step Error Help Context ID:1100 >> > >> > Any help will be appreciated. >> > Thanks, OV
- Next message: Randall: "New transaction cannot enlist in the specified transaction coordinator"
- Previous message: Andrew Gale: "overwrite existing record"
- In reply to: OV: "Re: Problem with nightly runs"
- Next in thread: Sue Hoegemeier: "Re: Problem with nightly runs"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
