About Me

My photo
I am an MCSE in Data Management and Analytics, specializing in MS SQL Server, and an MCP in Azure. With over 19+ years of experience in the IT industry, I bring expertise in data management, Azure Cloud, Data Center Migration, Infrastructure Architecture planning, as well as Virtualization and automation. I have a deep passion for driving innovation through infrastructure automation, particularly using Terraform for efficient provisioning. If you're looking for guidance on automating your infrastructure or have questions about Azure, SQL Server, or cloud migration, feel free to reach out. I often write to capture my own experiences and insights for future reference, but I hope that sharing these experiences through my blog will help others on their journey as well. Thank you for reading!

Could not load file or assembly 'msddsp, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a'

Issue:-
when we double click on the Maintenance plans to modify or Execute, under Management --> Mainteance Plans. We get below 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)





In order to resolve this error...

In your existing envirnment, copy this Folder from Any good Server, the source server from where you are getting this file should have same version of Windows + SQL Server. 

Copy MSDesigners8 folder to
..\Program Files (x86)\Common Files\Microsoft Shared\MSDesigners8
\Resources 
  • msdds.dll 
  • msddsf.dll 
  • msddslm.dll 
  • msddslmp.dll 
  • msddsp.dll 

2. Register following DLLs with RegSvr32
  • msdds.dll 
  • msddsf.dll 
  • msddslm.dll 


3. Import following .NET assemblies 

  • msddslmp.dll 
  • msddsp.dll 
It actually works just dragging it and drop to ..\Windows\Assemblies 

If the above does not work:

Go to the source server to below path:
C:\windows\assembly\GAC_MSIL

Copy folders “msddslmp.dll” and “msddsp.dll” to “C:\windows\assembly\GAC_MSIL” path of target server.

your issue will get resolved. 

Thanks for Reading.. 
Labels: , , ,