I encountered a troubling message while playing around with SQL Server 2005 and its new Integration Services. It read, “Failed to save package file "C:\Documents and Settings\Adam Anderson\Local Settings\Temp\tmp44F.tmp" with error 0x80029C4A "Error loading type library/DLL.".”
I first saw the error when I tried to create an Integration Services project in Visual Studio 2005, but the project was created anyway. I opened the project and ignored the error, hoping it was merely a glitch. However, after setting up a data source, I tried to add a package, and was blocked by the same error message. Now I knew I was in trouble. This was a brand-new installation, and it was annoying to see such an uninformative message, which is usually a sign that something has gone wrong at a fundamental level. Fortunately, my situation was not unique, and a search on Google quickly brought me to the correct solution.
It turns out that the MSXML 6.0 Parser was either incompletely installed or the installation was damaged.
To fix:
- Start Menu | Control Panel | Add or Remove Programs
- Locate MSXML 6.0 Parser in the list
- Click Change. The Setup dialog will appear.
- Click Next.
- There will be two options: Repair and Remove. Select Repair, then click Next.
- The Setup dialog will display a progress bar and then (hopefully) report success.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=413294&SiteID=1
