DTS Load problem

[OV]

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

 

[Snowcrash]

You might need to look at what other processes you have running on other apps at the same time. It could be that the 2 processes are using the same libraries. It is hard to imagine why it would happen so (aparently) randomly otherwise.

Snowcrash