Solved

Can't Open Existing or Create New SSIS projects

Posted on 2008-10-20
16
594 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
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
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 
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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
I have a large data set and a SSIS package. How can I load this file in multi threading?
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
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

773 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