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

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 (AT) hotmail (DOT) com> wrote

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 (AT) shadhawk (DOT) com> wrote

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 (AT) hotmail (DOT) com> wrote

DTS is still a client. It can lose connectivity to the
server. I'd check the event logs, SQL Server logs and run
some traces as Andrew suggested.

-Sue

On 18 Oct 2004 07:10:57 -0700, gnews84 (AT) hotmail (DOT) com (OV)
wrote: