September 2, 2014 at 8:09 am
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.
September 3, 2014 at 3:27 am
It means the task was cancelled.
Ref:
http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.dts.runtime.wrapper.dtsexecresult.aspx
September 3, 2014 at 5:02 am
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