Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

DTExec: The package execution returned DTSER_FAILURE (1) Expand / Collapse
Author
Message
Posted Tuesday, June 26, 2012 10:31 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, March 26, 2014 10:46 AM
Points: 2, Visits: 70
@strugdt, This worked like a charm... thx dude..
Post #1321388
Posted Monday, July 29, 2013 7:32 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, October 30, 2013 6:37 AM
Points: 1, Visits: 7
Hi there, I'm hoping strugdt fix will work for me. however I'm still a newbie, where do I insert that code into? the SQL server agent job, or other?

Thanks!
Post #1478584
Posted Thursday, August 22, 2013 2:22 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, January 3, 2014 8:02 AM
Points: 25, Visits: 53
Watch out with this one! Allow updates option in sql server

strugdt (7/14/2011)
Guys,

I had the same issue running packages (maintenance plans) on SQL Server 2008 64-bit. Here's is what I did and all you need to do as well -

sp_configure 'allow updates',0
go

reconfigure with override
go

And it should work.
Post #1487110
Posted Wednesday, October 30, 2013 6:08 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, December 3, 2013 3:14 AM
Points: 1, Visits: 6
strugdt (7/14/2011)
Guys,

I had the same issue running packages (maintenance plans) on SQL Server 2008 64-bit. Here's is what I did and all you need to do as well -

sp_configure 'allow updates',0
go

reconfigure with override
go

And it should work.


Works for me with SQL Server 2008 Standard (Index Reorganisation Maintenance Plan)! Thank you!!!
Post #1509734
Posted Wednesday, October 30, 2013 3:06 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, June 20, 2014 12:03 PM
Points: 2, Visits: 23
I had the same issue and the following solution worked for me... thanks

sp_configure 'allow updates', 0
reconfigure with override
Post #1509953
Posted Tuesday, November 26, 2013 8:26 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Yesterday @ 12:38 PM
Points: 72, Visits: 313
Much simpler fix for me.

Modify plan, edit backup task, don't change anything but select the OK button, save plan.

http://www.sqldbadiaries.com/2010/09/19/backup-job-failes-with-error-the-package-execution-returned-dtser_failure-1/
Post #1517716
Posted Friday, December 6, 2013 2:36 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, December 6, 2013 2:30 PM
Points: 1, Visits: 0
inevercheckthis2002 (11/26/2013)
Much simpler fix for me.

Modify plan, edit backup task, don't change anything but select the OK button, save plan.

http://www.sqldbadiaries.com/2010/09/19/backup-job-failes-with-error-the-package-execution-returned-dtser_failure-1/


exactly in my case, though I run the sp_configure 'Allow Updates', 0
Post #1520752
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse