Solved

Can't Open Existing or Create New SSIS projects

Posted on 2008-10-20
16
596 Views
Last Modified: 2013-11-10
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
Comment
Question by:troyab
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 7
  • 2
16 Comments
 
LVL 32

Expert Comment

by:bhess1
ID: 22769447
Re-download the MSXML6 package and re-install / repair it.  This frequently will fix this issue.
0
 

Author Comment

by:troyab
ID: 22772228
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
 
LVL 22

Expert Comment

by:PedroCGD
ID: 22774609
Could you try to open in another machine?
Regards!
0
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
LVL 32

Expert Comment

by:bhess1
ID: 22778641
This is on Vista?  Hmmm......
0
 
LVL 22

Expert Comment

by:PedroCGD
ID: 22778758
maybe... :-)
try another machine and give feedback!
:-)
0
 

Author Comment

by:troyab
ID: 22782082
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
 

Author Comment

by:troyab
ID: 22782105
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
 
LVL 22

Expert Comment

by:PedroCGD
ID: 22783685
try also to install cumulative package 9 of SQL Server
0
 

Author Comment

by:troyab
ID: 22784547
No luck. The cumulative update did a fair bit of work but didn't solve the problem...
0
 
LVL 22

Expert Comment

by:PedroCGD
ID: 22784728
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
 

Author Comment

by:troyab
ID: 22792318
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
 
LVL 22

Expert Comment

by:PedroCGD
ID: 22794639
And the laptop has Windows Vista, correct?
Is only the difference?!
Regards
0
 

Author Comment

by:troyab
ID: 22794683
That is correct. SSIS 2005 has been working fine on this Vista laptop for quite a while..
0
 

Accepted Solution

by:
troyab earned 0 total points
ID: 22819945
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
 
LVL 22

Expert Comment

by:PedroCGD
ID: 22820226
Good!!!!
Regards!
pedro
0
 
LVL 22

Expert Comment

by:PedroCGD
ID: 22830009
"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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question