Share via

Failed to Create Maintenance Plan in SQL Server 2019 show Exception from HRESULT: 0xC0014001 (Microsoft.SqlServer.DTSRuntimeWrap)

Muhammad Danial Nu'man Noorman 0 Reputation points Microsoft Vendor
2024-07-22T06:12:07.33+00:00

Hi,

I have been trying to create maintenance plan using maintenance plan wizard in SSMS. As i go through the plan, the prompt show error 'Saving maintenance plan failed' with Exception from HRESULT: 0xC0014001 (Microsoft.SqlServer.DTSRuntimeWrap). The details error messages state as:

Exception from HRESULT: 0xC0014011 (Microsoft.SqlServer.DTSRuntimeWrap)

Program Location:

at Microsoft.SqlServer.Dts.Runtime.Application.SaveToSqlServerAs(Package package, IDTSEvents events, String packagePath, String serverName, String serverUserName, String serverPassword)

at Microsoft.SqlServer.Management.DatabaseMaintenance.MaintenancePlan.Save()

at Microsoft.SqlServer.Management.MaintenancePlanWizard.MaintenancePlanWizardForm.PerformActions()

===================================

Exception from HRESULT: 0xC0014011 (Microsoft.SqlServer.DTSRuntimeWrap)

Program Location:

at Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass.SaveToSQLServerAs(IDTSPackage100 pPackage, IDTSEvents100 pEvents, String bstrPackagePath, String bstrServerName, String bstrServerUserName, String bstrServerPassword)

at Microsoft.SqlServer.Dts.Runtime.Application.SaveToSqlServerAs(Package package, IDTSEvents events, String packagePath, String serverName, String serverUserName, String serverPassword)

Error

Is there any workaround that i can work out? FYI, SSIS already enabled.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,345 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 107K Reputation points
    2024-07-22T19:27:42.7266667+00:00

    One very popular workaround is to scrap the builtin maintenance plans and use Ola Hallengren's maintenance solution instead.

    0 comments
  2. LucyChenMSFT-4874 2,995 Reputation points
    2024-07-23T01:42:09.7533333+00:00

    Hi @Muhammad Danial Nu'man Noorman,

    Thank you for your reaching out and welcome to Microsoft Q&A!

    Agree with Erland's answer, I would like to introduce the solution from Ola Hallrngren for database maintenance work. Using Ola Hallrngren' script's is a good method that many professionals use.

    ola.hallengren.com

    If you don't want to use it, you can try to create a new backup maintenance plan, use exactly the same steps and parameters as before.

    In addition, you might find more details about what fails by executing the maintenance plan in the command line with the dtexec utility. You'll find the command parameters to use in the SQL Server Agent Job that runs the maintenance plan. In the properties of the job, edit the step that runs the maintenance plan.

    Feel free to share your issues here if you have any concerns!

    Best regards,

    Lucy Chen

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    https://docs.microsoft.com/en-us/answers/support/email-notifications