Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 607
  • Last Modified:

Can't Open Existing or Create New SSIS projects

Hi All

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.

Thanks,
Troy
0
troyab
Asked:
troyab
  • 7
  • 7
  • 2
1 Solution
 
Brendt HessSenior DBACommented:
Re-download the MSXML6 package and re-install / repair it.  This frequently will fix this issue.
0
 
troyabAuthor Commented:
Hi
This made no difference. Installing was successful, repairing even after installing says the product isn't installed. I have tried the MS Installer cleanup as well as per other posts but it does not appear in the list. I have heard that MSXML6.1 is part of Vista so can't be touched..
0
 
PedroCGDCommented:
Could you try to open in another machine?
Regards!
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Brendt HessSenior DBACommented:
This is on Vista?  Hmmm......
0
 
PedroCGDCommented:
maybe... :-)
try another machine and give feedback!
:-)
0
 
troyabAuthor Commented:
I will try and open my package on another machine, but like I said above, I am also not able to create New SSIS projects/packages which points to a problem on my laptop.
0
 
troyabAuthor Commented:
And as much as I don't want to have to re-iamge my machine, I am thinking that will be my only option... SSIS 2005 has been working fine on Vista for quite a while with no hiccups so I know it isn't a compatibility.. Something has just gone a bit screwy :-(
0
 
PedroCGDCommented:
try also to install cumulative package 9 of SQL Server
0
 
troyabAuthor Commented:
No luck. The cumulative update did a fair bit of work but didn't solve the problem...
0
 
PedroCGDCommented:
you dont have a machine with another operational system to test?
do you want me to test your project in one of my machines...
Regards
0
 
troyabAuthor Commented:
I have opened my project on another machine and the project is fine, no corruption at all.. Which goes back to the laptop being stuffed somehow.
0
 
PedroCGDCommented:
And the laptop has Windows Vista, correct?
Is only the difference?!
Regards
0
 
troyabAuthor Commented:
That is correct. SSIS 2005 has been working fine on this Vista laptop for quite a while..
0
 
troyabAuthor Commented:
Hi All
 
I have bitten the bullet and re-imaged my laptop and completely reloaded everything and it is now working fine again.
 
Thanks for your time.
0
 
PedroCGDCommented:
Good!!!!
Regards!
pedro
0
 
PedroCGDCommented:
"Re-imaged my laptop so the problem was never resolved."
Because the solution was really re-imaged the laptop, so, consider ID: 22819945 the solution for this question! :-)
Regards!!
Pedro

www.pedrocgd.blogspot.com
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 7
  • 7
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now