Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Error when trying to modify maintenance plan

Author  Topic 

sqladmin86
Starting Member

2 Posts

Posted - 2011-08-25 : 13:53:44
I have recently started a sql admin position and would like to make some changes to previous persons' maintenance plan however when I try to modify the maintenance plan I get the following error:

could not load file or assembly 'msddsp, version=9.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a' or one of its dependencies. the system cannot find the file specified. (microsoft.datatransformationservices.design)

My SQL Server is installed on Windows 2008 Standard R2. I have also checked the Help of SSMS to see if somehow something was installed that was not the right version below is what it looks like:

Microsoft SQL Server Management Studio 10.0.2531.0
Microsoft Analysis Services Client Tools 10.0.1600.22
Microsoft Data Access Components (MDAC) 6.1.7601.17514
Microsoft MSXML 3.0 5.0 6.0
Microsoft Internet Explorer 8.0.7601.17514
Microsoft .NET Framework 2.0.50727.5446
Operating System 6.1.7601

Thanks for any help

sqladmin86
Starting Member

2 Posts

Posted - 2011-08-25 : 14:57:19
Looking at the \Setup Bootstrap\Log\ directory log files I noticed that there is an instance of SQL Express installed. However when I go to programs and features to uninstall it's not listed. Could this be my problem and if so how can I uninstall SQL Express?
Go to Top of Page
   

- Advertisement -