?
Solved

Can't Open Existing or Create New SSIS projects

Posted on 2008-10-20
16
Medium Priority
?
602 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:Brendt Hess
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
Congratulations! You’re Certified – Now What?

Starting a new career can be overwhelming. Becoming certified in your field of expertise is a great start, but where do you go from here?  Here are some tips to help you on your career journey.

 
LVL 32

Expert Comment

by:Brendt Hess
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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how the fundamental information of how to create a table.
Suggested Courses

765 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