Error generated loading DTSX file into IDE

"Unable to instantiate XML DOM document, please verify that MSXML binaries are properly installed and registered."

 
I have recently been developing some DTSX packages on my laptop within my VS 2005 IDE and needed to continue the work on a remote machine the following day. Having checked my files into the source control and got the latest version on the remote machine I attempted to open the same packages from within the VS 2005 IDE on the remote machine. The same packages that I had completed the previous day on my laptop were refusing to open cleanly, presenting me with a numbr of error messages and had lost the Data Flow items in my package.
 
Knowing that I had my files under source control, and stored on my laptop, I knew I could retrieve the files again without too much hassle but I needed to find out why they were not loading successfully in this particular IDE. A quick search of the digital cloud provided this little nugget of information http://bisqlserver.blogspot.com/2008/05/ssis-error-opening-packages-msxml.html. Having applied the suggested solution on the remote machine I was able to open my packages without any errors or loss of content.
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s