Sql-server – Error when trying to open SQL Maintenance Plan – SSMS 2008

maintenancesql serversql-server-2008ssms

If I open SSMS on my client machine, connect to our SQL server, and try and open a maintenance plan on there, I get this error:

TITLE: Microsoft SQL Server Management

Studio

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)

—————————— BUTTONS:

OK

If i try the same thing directly on the server, nothing happens (no errors or anything)

Best Answer

I had this error message whenever I opened a Maintenance Plan.

Was running:

  • Windows Server 2008 SP2
  • SQL Server 2008 R2 10.50.1617.0
  • SQL Server Management Studio 10.50.1617.0

I downloaded and installed SQL Server Management Studio SP1 (SQLManagementStudio_xxx_ENU) - didn't even upgrade the server itself, and was able to open up Managment Plans after that. Now I have:

  • SQL Server 2008 R2 10.50.1617.0
  • SQL Server Management Studio 10.50.2500.0

I noticed that after installing this, I have the correct version of msddsp installed into the GAC.

enter image description here

Otherwise, maybe this will work for you?:

Related Topic