Hi,
This is for developers suffering from the following error:-
Quote:
The specified module could not be found. (Exception from HRESULT: 0x8007007E) (System.Windows.Forms)
It took me more than a day to figure out as why I get the above error when I try to open control flow design by double clicking on a *.dtsx package in Microsoft Visual Studio 2008.
The famous resolution as many of you know is to replace all the 5 DLL's [msdds.dll, msddsf.dll, msddslm.dll, msddslmp.dll, msddsp.dll] in the following location 'C:\Program Files (x86)\Common Files\microsoft shared\MSDesigners8' with fresh copy of dll's from a working machine.
Issue persisted even after replacing fresh copy of DLL's from other working machine.
Then I realised the DLL's that are replaced, each was designed for Visual Studio 2012 (in DLL properties) and my machine did not have VS-2012(as I uninstalled it few days back), latest Visual Studio version was 2008. That's it, I managed to find one such colleage who had Visual-Studio not latest than VS-2008, took the DLL's from his 'MSDesigners8' folder, copied to my machine, launched the SSIS package from VS-2008 and it works.
Note : Make sure the DLL's version match the latest VisualStudio version in your machine. In this case, SSIS opened in Ms-VS-2008 tried to use DLL's with Ms-VS-2012 version and which were not replaced with 2008 designer DLL's when VS-2012 was uninstalled.
Problem that Microsoft must resolve: If latest version of VisualStudio is installed on a machine having multiple Visual Studio versions (2k3,2k5,2k8, 2010, 2012 etc..), the common/shared DLL's that ship with it replace existing version DLL's. But when latest version is uninstalled, those DLL's are left behind, and when previous version of VStudio needs a common DLL then it error's out as it's trying to refer to a DLL which is of advanced version and that version VS is not in the system.
Cheers...