2008 SSIS Designer stops working after installing VS11 Dev Preview
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)
September 27th, 2011 12:34pm
:) 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
September 27th, 2011 1:24pm
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!
December 6th, 2011 10:38am
Thanks George! That did the trick.
February 2nd, 2012 12:03pm
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!
February 17th, 2012 9:44am
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)
February 22nd, 2012 5:39am
Thank you George, that did the trick.
February 29th, 2012 2:34pm
Wow, brutal, I got stuck by this as well, after the file copy all ok again for me as well.
March 7th, 2012 7:23pm
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
March 29th, 2012 7:18pm
Thanks G - this solution worked for me too!
April 13th, 2012 9:29am
Thanks for the post. I was about to throw my machine out a window and start over.
April 16th, 2012 2:13pm
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
May 2nd, 2012 4:08am
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.
May 19th, 2012 2:53pm
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.
May 20th, 2012 3:11pm