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

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)

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.
  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)

SQL Error Messages, SQL Server, SQL Server Management Studio, SSMS, Virtualization
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

2 Comments. 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

  • Hi Manish, I have been facing same issue. have you came across any alternate solution that you can suggest me


Leave a Reply Cancel reply

Exit mobile version