sql server dts: While running DTS, happens randomally in different tasks.

I've been having a similiar issue. I've scheduled a group of DTS packages
and a stored procedure to run over night. I've been getting a random error
when the stored procedure begins.


DTSRun OnError: DTSStep_DTSExecutePackageTask_2, Error = -2147467259
(80004005)

Error string: DTSStep_DTSExecuteSQLTask_1: [DBNETLIB][ConnectionRead
(recv()).]General network error. Check your network documentation.

Error source: Microsoft OLE DB Provider for SQL Server

It usually runs fine if I run it manually. The errors usually happen when
the procedure runs over night. The server logs don't show anything else
running at that time.

Does anyone have an idea?


[quoted text, click to view]