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

Question

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)

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

Answer 1

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

Answer 2

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