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)
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.
- 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
- Repair SQL Server along with client components. This can be done by choosing option in SQL Setup.
- 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.
- 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)