Can't Open Existing or Create New SSIS projects
Posted on 2008-10-20
I am currently having a problem opening an existing SSIS project I have been working on for the last few weeks. I am using Visual Studio Team Suite 2005 SP1/SQL Server 2005 SP2 on Vista Enterprise SP1.
The error I get is:
TITLE: Microsoft Visual Studio
There were errors while the package was being loaded.
The package might be corrupted.
See the Error List for details.
Error loading BUAR_Extract_Belise.dstx: Unable to instantiate XML DOM document, please verify that MSXML binaries are properly installed and registered.
I have also tried creating a new SSIS project to verify if my project is indeed corrupt. This gives the error:
- Failed to save package file "C:\Users...." with error 0x80040155 "Interface not registered"
I have searched the Web and found the solution to re-register MSXML3/MSXML6 but this has not worked although the messagebox says it was successful.
I have just finished uninstalling/re-installing SQL Server 2005/VSTS 2005 and the problem is still persisting.
Can anyone please shed some light on this for me.