Search This Blog

Saturday, February 9, 2008

DTExec: The package execution returned DTSER_FAILURE (1)

Is your M-Plan failing ......and you are getting this error :
Message
Executed as user: TMMCADM\ClusterSQL. Microsoft (R) SQL Server Execute Package Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started:
11:35:48 AM Progress: 2008-01-30 11:35:49.11 Source: {3764B470-DBB1-4A59-978D-E2CE331A1AF2} Executing query "DECLARE @Guid UNIQUEIDENTIFIER EXECUTE msdb..sp".: 100%
complete End Progress DTExec: The package execution returned DTSER_FAILURE (1). Started: 11:35:48 AM Finished: 11:35:49 AM Elapsed: 1.218 seconds. The package execution failed. The
step failed.


Check the sp_configure values and see if "allow updates" is set to 1 by mistake ..
reset it to 0 and you are done ......

No comments: