CODEWITHSUNDEEP
ssisvisual-studio-2019sql-server-2017
Supriyo Bhattacherjee
Supriyo Bhattacherjee

Reputation: 563

SSIS Validation Error "xml source adapter does not support mixed content model on complex types"

I am trying to parse an XML, But I am getting an error as "XML source adapter does not support mixed content model on complex types" while using the XML Source in Dataflow. I don't have much experience in SSIS, I need some suggestion.

enter image description here

Upvotes: 0

Views: 1457

Answers (1)

Ferdipux
Ferdipux

Reputation: 5246

The error message is quite self-explanatory -- SSIS XML Source cannot handle mixed content model.
Example of mixed model data - when node text is mixed with sub nodes.

<description>character data <br/> more text <br/> and <strong>more data</strong></description>

You have to inspect your XML document and its schema, and transform it with XSLT to an XML without mixed data. It can be done with SSIS XML Task before running Data Flow XML Source.

Upvotes: 1

Related Questions