This morning, I went to open some packages that I had been working on last week, and was surprised (and a little panicked!) to get an error saying that the package couldn't be opened. After clicking OK, the package seemed to be fine - in the Control Flow - however my data flows were empty! Looking at the message in the Error tab scared me even more!
"Unable to instantiate XML DOM document, please verify that MSXML binaries are properly installed and registered."
I hoped it was just my local version of the packages, so I re-pulled the files out of source control, however, I still got the same error! (this is when the panic really started setting in!)
After some digging, I found that you can repair the binaries by going into 'Add/Remove Programs', clicking 'Change' on the 'MSXML 6.0 Parser', and selecting the 'Repair' option (shown below). After doing this, the packages opened just fine.
Hope this helps ...
(Whew! not a fun way to start a Monday!)
沒有留言:
張貼留言