SQL SERVER – Maintenance Plan Error: Cannot Create a Task From XML For Task, Eue to Error 0x80070057. The Parameter is Incorrect. (OnPreExecute)

SQL
1 Comment

Once I encountered an error while creating new maintenance plans on my virtual machine.

TITLE: Microsoft SQL Server Management Studio
——————————
Cannot create a task from XML for task “”, type “” due to error 0x80070057 “The parameter is incorrect.”. (OnPreExecute)
——————————
Program Location:
at Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSExecutables100.Add(String bstrMoniker)
at Microsoft.SqlServer.Dts.Runtime.Executables.Add(String moniker)

Solarwinds

I had no idea about this error, so I started searching for possible causes on the internet. I was surprised to see that this was a common error. I was able to find multiple solutions to fix this issue. One of them worked for me so I am summarizing all of them here.

  1. This one worked for me. Download and install “SQL Server Data Tools in Visual Studio 2015”. This is also called as SSDT. https://msdn.microsoft.com/en-us/mt186501
  2. Repair SQL Server along with client components. This can be done by choosing option in SQL Setup.
    SQL SERVER - Maintenance Plan Error: Cannot Create a Task From XML For Task, Eue to Error 0x80070057. The Parameter is Incorrect. (OnPreExecute) ssms-plan-err-01-800x383
  3. Connect to SQL Server remotely and use SSMS from that machine. This is a good practice because generally it’s not preferred to do such things on the server itself.
  4. Install SQL Server free version from http://aka.ms/ssms latest version would be advisable.

Try your luck and share in comments, which solution worked for you. Let me know if you know any other way to fix similar error related to maintenance plans.

Reference: Pinal Dave (https://blog.sqlauthority.com)

Solarwinds
, , , ,
Previous Post
SQL SERVER – Don’t Ignore Warning: Cluster Resource DLL Update Restart Check
Next Post
SQL SERVER- Unable to Failover AlwaysOn Availability Group to Disaster Recovery Site

Related Posts

1 Comment. Leave new

  • Apparently I cannot use above approach on client machine. However, I am trying to run ssis package and getting same error. Please suggest if you think of any solutions

    Reply

Leave a Reply

Menu