Immediately after installing the Visual Studio 11 Developer Preview, I was no longer able to open a SSIS package in VS 2008. I uninstalled it and all the .NET 4.5 associated packages, reinstalled both VS 2008 and SQL 2008, but still it refuses to work. This is the specific error I get when attempting to open one. =================================== An error prevented the view from loading. (Microsoft Visual Studio) =================================== The specified module could not be found. (Exception from HRESULT: 0x8007007E) (System.Windows.Forms) ------------------------------ Program Location: at System.Windows.Forms.UnsafeNativeMethods.CoCreateInstance(Guid& clsid, Object punkOuter, Int32 context, Guid& iid) at System.Windows.Forms.AxHost.CreateWithoutLicense(Guid clsid) at System.Windows.Forms.AxHost.CreateWithLicense(String license, Guid clsid) at System.Windows.Forms.AxHost.CreateInstanceCore(Guid clsid) at System.Windows.Forms.AxHost.CreateInstance() at System.Windows.Forms.AxHost.GetOcxCreate() at System.Windows.Forms.AxHost.TransitionUpTo(Int32 state) at System.Windows.Forms.AxHost.CreateHandle() at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible) at System.Windows.Forms.Control.CreateControl() at Microsoft.DataWarehouse.Design.ComponentDiagram.CreateDdsView(Control parentControl) at Microsoft.DataTransformationServices.Design.DtsComponentDiagram.CreateDdsView(Control parentControl) at Microsoft.DataWarehouse.Controls.DdsDiagramHostControl.set_ComponentDiagram(ComponentDiagram value) at Microsoft.DataTransformationServices.Design.ControlFlowControl.set_ComponentDiagram(ComponentDiagram value) at Microsoft.DataTransformationServices.Design.DtsPackageView.CreateControlFlowEditor(VsStyleToolBar pageViewToolBar) at Microsoft.DataWarehouse.Design.EditorWindow.EnsureViewIsLoaded(EditorView view)

:) I faced the same issue when I installed DENALI on my system. I removed Denali from my system and repaired the SQL Server 2008 and things started working for me.My Blog | Ask Me

Just for future reference (and for any unfortunate soul that comes here hoping for a solution), just repairing didn't work in my case. I hadn't installed DENALI on my PC, just Visual Studio 11. Apparently VS11 also updates the "Microsoft Design Tools - Diagram Surface", which are also used by Visual Studio 2008. After some procmon sessions, I found out that msdds.dll tries to search for MSVCR110.dll, which of course isn't there when you have uninstalled Visual Studio 11 (technology preview at that point) I solved the problem by deleting the whole folder "C:\Program Files (x86)\Common Files\microsoft shared\MSDesigners8", and copying it from a machine that was working. Not the smoothest solution, I know, but it did work!

Thanks George! That did the trick.

Yes, thank you George! Before I deleted my folder I did a compare of the contents and the compare showed that the folders (existing and new) were identical. It didn't start working until I actually deleted the old one and replaced it. Why this is the case is beyond me, but it works now. Your direction has been MUCH appreciated!

I started getting this problem after installing SP1 for SQL Server 2008 R2, even though it finished successfully! Repair didn't work, the trick with the files copied from a working machine did. Thanks!!MCITP SQL Server 2008 (DEV); MCTS SQL Server 2008 (BI, DEV & DBA)

Thank you George, that did the trick.

Wow, brutal, I got stuck by this as well, after the file copy all ok again for me as well.

Thank you George!!!! You have no idea how long I have been trying to figure this out. Unfortunately, the way msdn is structured, you have to weed through all the thousands of "You might try this or maybe that" before you get to someone like you who says "I solve the problem by...". I think we should start reporting the clutterers as abuse so people like George can really stand out. Thank you again George. You are one in a million. Philbert

Thanks G - this solution worked for me too!

Thanks for the post. I was about to throw my machine out a window and start over.

George's solution works a treat. For me the problem was the ER diagram designer in SQL Server Management Studio stopped working, but it was exactly the same symptoms.Louis, author of Procreate

Hi I had the same problem. I managed to solve the problem by uninstalled Visual Studio 11, All SQL Server 2012 applications and SSDT. I also re-installed SQL Server 2008 R2 - Clients Tools and replied the Services Pack 1 and latest Cumulative Update. I also deleted the following folder "C:\Program Files (x86)\Common Files\microsoft shared\MSDesigners8". I then finally replied the Visual Studio 2008 Service Pack 1.

Hi I had the same problem. I managed to solve the problem by uninstalled Visual Studio 11, All SQL Server 2012 applications and SSDT. I also re-installed SQL Server 2008 R2 - Clients Tools and replied the Services Pack 1 and latest Cumulative Update. Finally replied Visual Studio 2008 Service Pack 1.