While running DTS, happens randomally in different tasks.

anyone?

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?


"חן" wrote: