I have a DTS local package that's scheduled via the SQL Server Agent. This job, when it runs normally, takes less than a minute to run. Periodically, the job will hang. When I examine the job in Enterprise Manager, I find that the job status is still "Executing". I then have to stop the job from running. If I then execute the job manually, it runs to completion normally.

The SQL Server Log records the following: "Error: 1073759806, Severity: 1, State: 0", but I can't find anything that explains what this error is.

Does anyone know what this error message means or why my DTS package will sometimes hang when run through the SQL Server Agent?