Unable to instantiate XML DOM document, please verify that MSXML...

Working with SSIS - Sometimes a pain, sometimes not.

Working with SSIS lately on a project after about a year and a half layoff from it, it's good to be back to building packages. I especially enjoy the coding, expressions, VB.Net and the like (I'm one of those DBAs from previous versions who knew how to write extended stored procedures in C and C++, great stuff!). I received an error the other day: Unable to instantiate XML DOM document, please verify that MSXML binaries are properly installed and registered.

This is easily solved by simply uninstalling and reinstalling the MSXML 6.0 parser. Before you do though, go to the command line and type regsvr32 msxml6.dll first and see if that solves your problem. I have found that for some reason the parser gets hacked up, maybe after hotfixes or security patches I have no idea. There is a service pack that is available for download as well that might be worthwhile.

Lee

-----------------------

Fighting problems all day - still fun after all of these years!