Monthly Archives: September 2008

dtproj File Error

Posted on by
Reply
"There was an error generating the XML document."
 
I have been developing a number of items in a multi-project solution within BIDS (Business Intelligence Developer Studio) and then the other day, after adding a new DTSX package to my SSIS project, I started to get an error saving the project file (dtproj). All the Visual Studio message box would tell me is ‘There was an error generating the XML document.’ and then I was presented with the ‘Save File As’ dialog box. To fix the problem I tried…
  • Overwriting the dtproj file when the ‘Save File As’ dialog box was displayed.
  • Checking the dtproj file back in SourceSafe.
  • Closing the solution, without saving the changes to the project, re-opening the solution, re-adding the new DTSX file and saving the project file changes.
  • Getting an earlier version of the dtproj file from SourceSafe and re-insterting the existing items to the project and saving the project file changes.

All of the above attempts proved to be in vain as I was just presented with the same message box. After checking my dtproj file differences within SourceSafe it occurred to me that I should edit the dtproj file within Notepad and see if that resolved the problem. I added a couple of new entries into the dtproj file for the new items that were included in my SSIS project and saved the changes. When I clicked back to my open project, Visual Studio recognised that changes had been made to the dtproj file and asked me if I wished to reload the file? I clicked ‘Yes’, the project file reloaded successfully and have been able to continue working with my SSIS project without further error messages.

Error generated loading DTSX file into IDE

Posted on by
Reply
"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.

VS 2005 SP1 Installation Problem

Posted on by
Reply
"The installation source for this product is not available."
 
I recently had to install VS 2005 SP1 on a Windows 2003 server that was hosting a development environment. After firing up the setup process I was presented with this error message on my screen;
 

                                       Capture

Looking in the Event Log I also found this entry around the time the error message was generated;

Event Type:Error
Event Source:MsiInstaller
Event Category:None
Event ID:1008
Date:12/18/2006
Time:12:18:31 PM

Description:
The installation of C:DOCUME~1…LOCALS~1TempZNWA0VS80sp1-KB926601-X86-ENU.msp is not permitted due to an error in software restriction policy processing. The object cannot be trusted.

After doing a bit of research I came across others who had experienced the same problem and they directed me to this Knowledge Base artcile http://support.microsoft.com/default.aspx/kb/925336 which provided the solution. After applying the update and rebooting the server I was able to install the Service Pack.