SSIS Package opens with errors after installing Visual Studio 2010
Last week I installed Visual Studio Premium 2010, and today I had to open a SSIS 2008 package. To my dismay when I opened it I got the following error (Unable to instantiate XML DOM document, please verify that MSXML binaries are properly installed and registered) among others.
After a bit of Googling I found a post the suggested to re-install MSXML6 which I tried but it gave an error that a newer version is already installed (probably by VS2010). After more Googling I found a post over at SQL Server Central which suggested the following:
Run the following to lines:
regsvr32 msxml3.dll
regsvr32 msxml6.dll
And voilà my packages are working, now I just hope it didn’t break something else.