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