Edition upgraded after Maintenance plan was failed?

• SQL Galaxy

  One Orange Chip

  Points: 29472

  More actions

  May 22, 2013 at 10:03 pm

  #274109

  Hi,

  Recently upgraded done from standard edition to enterprise edition and SP3, after that Backup maintenance plan was corrupted then it was working after restart server again get it failed automatically after 3 or 4 days..

  Please suggestion me, if any need to apply cumulative update patch on SQL Server 2008 enterprise edition SP3

  Error message

  Executed as user: Servername\ExpSQLAgtSvc. Microsoft (R) SQL Server Execute Package Utility Version 10.0.5500.0 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 12:10:01 AM Error: 2013-05-23 00:10:01.69 Code: 0xC0010018 Source: Description: Error loading value "<DTS:ConnectionManager xmlns:DTS="www.microsoft.com/SqlServer/Dts"> <DTS:Property DTS:Name="DelayValidation">0</DTS:Property> <DTS:Property DTS:Name="ObjectName">Local server connection</DTS:Property> <DTS:Property DTS:Name="DTSID">{11A126D7-9C4A-417A-9" from node "DTS:ConnectionManager". End Error Could not load package "Maintenance Plans\DB_Backup" because of error 0xC0010014. Description: One or more error occurred. There should be more specific errors preceding this one that explains the details of the errors. This message is used as a return value from functions that encounter errors. Source: Started: 12:10:01 AM Finished: 12:10:01 AM Elapsed: 0.686 seconds. The package could not be loaded. The step failed.

• Andrew G

  SSChampion

  Points: 12809

  More actions

  May 22, 2013 at 10:57 pm

  #1617680

  http://sqlaj.wordpress.com/2010/01/12/t-sql-tuesday-002-a-puzzling-situation-the-package-failed-to-load-due-to-error-0xc0011008/

  Looks like you need to edit the package in the new edition and save again. Or follow the instructions in the link