SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 Unable to open existing package		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

goris
Starting Member

1 Posts
Posted - 11/19/2009 :  18:17:20  Show Profile  Reply with Quote
Here is the deal:

Failed to load XML from package file due to error 0xC00CE556 "Invalid at the top level of the document. Line 652, Column 93". This happens when loading a package and the file cannot be opened or loaded correctly into an XML document. This can be the result of either providing an incorrect file name to the LoadPackage method or the XML file specified having an incorrect format.

This happens when I try to add existing package to opened project. The package was working fine yesterday, nothing has changed. The only thing is that files are copied from one machine to another.
Why does this happen? Second time or so...
Is there any way or utilty that can check dtsx XML file for errors?

svicky9
Posting Yak Master

United Kingdom
232 Posts
Posted - 01/17/2010 :  04:39:14  Show Profile  Visit svicky9's Homepage  Reply with Quote
The visual studio versions may be different on both machines.

Did you copy the entire solution or did you copy the dtsx files alone?

Try creating an empty SSIS solution and add the dtsx packages. Let me know if this works

http://www.sqlserver007.com
Go to Top of Page

fguiccia
Starting Member

Ireland
3 Posts
Posted - 04/01/2010 :  04:56:58  Show Profile  Reply with Quote
Thanks svicky9! I have that problem and your solution was the answer!

Ferruccio Guicciardi
BI Consultant
Go to Top of Page

ashrun1230
Starting Member

India
2 Posts
Posted - 01/20/2012 :  06:31:20  Show Profile  Reply with Quote
Same case here. I have followed the solution but it is not working for me. :(
Go to Top of Page

srinidhig
Starting Member

USA
4 Posts
Posted - 03/27/2012 :  10:55:15  Show Profile  Reply with Quote
quote:
Originally posted by ashrun1230

Same case here. I have followed the solution but it is not working for me. :(

I have the same issue. Any workaround for this?
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000