Today, I want to create an SQL Maintenance Plan in SQL 2005. In the folder three (under the SQL Server Instance name) I open the folder Management and right click on the folder Maintenance Plan and and select the option New Maintenance Plan.
After doing so I receive the following SQL error message:
The solution for this problem is in the error message.This error may indicate that you have serious problems with your Microsoft SQL Server 2005 installation, but as the error message says this error is caused by a type library that is not installed. (Not registered.) (dts.dll)
So next I open the command prompt to register this file.
After this command you will receive the following message.
Now you have to close the SQL Server Management Studio, when you reopen the management studio you can create your Maintenance plan.
Was once an enthusiastic PepperByte employee but is now working at Ivanti. His blogs are still valuable to us and we hope to you too.