SSIS: Failed to load XML from package file
I recently came across this error in one of our SSIS packages.
Description: Failed to load XML from package file
"C:\Path\To\Package.dtsx" due to error 0xC00CE508
"An invalid character was found in text content. Line 426, Column 104". 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. End Error Could not load package
"C:\Path\To\Package.dts" because of error 0xC00CE508.
I opened the package in a text editor and this was at line 426
Execute SQL Task; Microsoft Corporation; Microsoft SQL Server v9; © 2004 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1
The dodgy character at column 104 was the copyright symbol. I think perhaps the package was opened up in notepad and saved screwing up the encoding. I opened the package in BIDS and re-saved it. Looking at the line again I could see it had changed. The package could execute successfully after this.