XML Destination - Handling Invalid Characters

Jun 8, 2009 at 8:23 PM

Hi I am trying to extract unicode data from Netezza to an XML output and I ran into this issue due to some bad data in the source. Looks like the source database has unicode control values which are treated as invalid characters by the XML specification used by the XML Destination Component.  Can anyone suggest possible work arounds to resolve this issue in SSIS ?

[DST XML Output [151]] Error: System.ArgumentException: '',
hexadecimal value 0x1D, is an invalid character.   
at System.Xml.XmlUtf8RawTextWriter.InvalidXmlChar(Int32 ch, Byte* pDst, Boolean entitize)
    at System.Xml.XmlUtf8RawTextWriter.WriteElementTextBlock(Char* pSrc, Char* pSrcEnd)
    at System.Xml.XmlUtf8RawTextWriter.WriteString(String text)
    at System.Xml.XmlWellFormedWriter.WriteValue(Object value)
    at DIMG.DataServices.Dts.XmlDestination.ProcessInput(Int32 inputID, PipelineBuffer buffer)
    at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostProcessInput(IDTSManagedComponentWrapper90 wrapper, Int32 inputID, IDTSBuffer90 pDTSBuffer,
IntPtr bufferWirePacket)