SSIS Dimension Processing Error: XML parsing failed at line X, column Y: Illegal xml character.
Without a doubt one of the most annoying and least useful errors I have ever encountered during my experience with SSIS.
This error has crept up on an SSIS packages that processes a dimension. The SSIS package is very simple and all it has is a OLE DB Source that dumps data from a query into a Dimension Processing task. The package executes fine until it reaches a particular row in the OLE DB source batch, in which it will fail with the following error message:
Dimension Processing Error: XML parsing failed at line 4, column 3391: Illegal xml character.
Descriptive!