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?

In article <24C06567-7420-4B17-81F1-7EB8A06A6D4E (AT) microsoft (DOT) com>, Scott wrote:

Could you perhaps be seeing this

http://support.microsoft.com/default...NoWebContent=1

What is in the Package?




Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
www.konesans.com - for all your consultancy needs