Solved

Can't Open Existing or Create New SSIS projects

Posted on 2008-10-20
16
597 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
Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

 
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

Is Your DevOps Pipeline Leaking?

Is your CI/CD pipeline a hodge-podge of randomly connected tools? You’ve likely got a tool to fix one problem & then a different tool to fix another, resulting in a cluster of tools with overlapping functionality. Learn how to optimize your pipeline with Gartner's recommendations

Question has a verified solution.

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

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
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…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.

734 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