SSIS Package opens with errors after installing Visual Studio 2010

Eugene Niemand
Eugene Niemand’s Blog
1 min readOct 28, 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.

--

--

Eugene Niemand
Eugene Niemand’s Blog

Data Solution Architect at ASOS - I have a passion for Test Driven Development, Agile Methodologies, Continuous Integration and Delivery using Microsoft Azure