Solved

Can't Open Existing or Create New SSIS projects

Posted on 2008-10-20
16
588 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
  • 7
  • 7
  • 2
16 Comments
 
LVL 32

Expert Comment

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

Author Comment

by:troyab
Comment Utility
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
Comment Utility
Could you try to open in another machine?
Regards!
0
 
LVL 32

Expert Comment

by:bhess1
Comment Utility
This is on Vista?  Hmmm......
0
 
LVL 22

Expert Comment

by:PedroCGD
Comment Utility
maybe... :-)
try another machine and give feedback!
:-)
0
 

Author Comment

by:troyab
Comment Utility
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
Comment Utility
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
Comment Utility
try also to install cumulative package 9 of SQL Server
0
Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

 

Author Comment

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

Expert Comment

by:PedroCGD
Comment Utility
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
Comment Utility
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
Comment Utility
And the laptop has Windows Vista, correct?
Is only the difference?!
Regards
0
 

Author Comment

by:troyab
Comment Utility
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
Comment Utility
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
Comment Utility
Good!!!!
Regards!
pedro
0
 
LVL 22

Expert Comment

by:PedroCGD
Comment Utility
"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

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
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…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

763 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

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now