Encounter error when deploying SSIS- Failed to load XML due to error 0xC00CE554 "Duplicate attribute. Line 16, Column 60"
Encounter the following error when deploying an SSIS package to server, any idea?
TITLE: SQL Server Integration Services
Failed to load XML due to error 0xC00CE554 "Duplicate attribute. Line 16, Column 60". This occurs when loading a package and the file cannot be opened or loaded correctly into the XML document. This can be the result of specifying an incorrect file name to the LoadPackage method or the specified XML file has an incorrect format.
Please try to create a new SQL Server Intergation Services project and add existing package into it to see if this issue still persists.
TechNet Community Support
Thank you guys.
It's really a weird a issue. I have managed to resolve the issue by copying those files in the project from another branch, and then deployment is successful.
Honestly I don't find any file with duplicate name. So the root cause remains unknown.
Anyway, this gives a lesson that it's always worthy to keep a working backup.