What does DTSER_CANCELED mean?

  • I have a package running from a job and its been running fine for quite some time. It failed recently with the following error but ran fine on the next scheduled attempts. What does the following error message mean?

    Microsoft (R) SQL Server Execute Package Utility Version 10.50.4000.0 for 32-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 6:00:01 AM DTExec: The package execution returned DTSER_CANCELED (3). Started: 6:00:01 AM Finished: 5:01:38 PM Elapsed: 39696.1 seconds. Process Exit Code 3. The step failed.

  • dndaughtery (9/2/2014)


    I have a package running from a job and its been running fine for quite some time. It failed recently with the following error but ran fine on the next scheduled attempts. What does the following error message mean?

    Microsoft (R) SQL Server Execute Package Utility Version 10.50.4000.0 for 32-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 6:00:01 AM DTExec: The package execution returned DTSER_CANCELED (3). Started: 6:00:01 AM Finished: 5:01:38 PM Elapsed: 39696.1 seconds. Process Exit Code 3. The step failed.

    My guess is that after 11 hours, someone canceled the job.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply