I ran into a couple errors recently when trying to create new SQL Server Integration Services (SSIS) projects. One error stated:
Failed to save package file "C:\Documents and Settings\Administrator\Local Settings\Temp\1\tmp2B.tmp" with error 0x80040155 "Interface not registered".
The other stated:
Failed to save package file "C:\Documents and Settings\Administrator\Local Settings\Temp\1\tmp2B.tmp" with error 0x80040154 "Class not registered".
These errors were encountered on a new laptop and a new virtual PC. Both had Visual Studio 2005 installed, so I suspected some sort of conflict. On the VPC, I loaded VS 2005 first, followed by SQL Server 2005 Developer. I noticed the client tools didn't install, although I thought I'd checked that box. To correct, I executed the setup for client tools. When completed, my client tools were available and creating an SSIS project succeeded.
But the laptop wasn't so simple. I thought "I have a solution!" and went about re-installing the client tools, but it didn't correct the issue!
So I popped on Google and searched for similar issues. I found a helpful post at MSDN Forums: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=53694&SiteID=1. Executing two RegSvr32 commands did the trick:
regsvr32 msxml3.dllregsvr32 msxml6.dll
When executed, I received the following messages:
When all else fails, read the instructions!
:{> Andy
