Unable to open existing package

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SSIS and Import/Export (2008)

Unable to open existing package

Author

Topic

goris
Starting Member

1 Post

Posted - 2009-11-19 : 18:17:20

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

232 Posts

Posted - 2010-01-17 : 04:39:14

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