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.

Like what you read? Give Eugene Niemand a round of applause.

From a quick cheer to a standing ovation, clap to show how much you enjoyed this story.