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

• Patrick.I

  Hall of Fame

  Points: 3105

  More actions

  June 9, 2009 at 7:04 pm

  #134977

  Hi guys,

  I want to load an xml file to sql server using the : Xml Source and the SQL Server Destination

  After generating the xsd as proposed by the XML source control i get the error:

  xml source adapter does not support mixed content model on complex types

  How can i get rid of this error and what shoudl i do to the complexType mixed="true"

  ?

  My XML and xsd below:

  13639

  wsoper

  MOP

  PRONTO

  AP

  04-04-09

  722

  90

  13639

  87

  1

  08-05-09

  16:54

  snikolou

  test

  127

  1

  01-06-09

  13:11

  snikolou

  please supply more details

  87

  1

  22-05-09

  14:04

  srussell

  IT cannot change user access unless notified by Payroll - Th

  2

  22-05-09

  14:04

  srussell

  come through from payroll yet.

  3

  22-05-09

  14:04

  srussell

  4

  22-05-09

  14:04

  srussell

  Please follow up with either Payroll or your Area Manager

  1

  22-05-09

  14:17

  srussell

  You have been given PRONTO test data access. You will need t

  2

  22-05-09

  14:17

  srussell

  and then in again for the change to take effect.

  3

  22-05-09

  14:17

  srussell

  4

  22-05-09

  14:17

  srussell

  MOP = LIVE DATA

  5

  22-05-09

  14:17

  srussell

  POS = TEST DATA

  6

  22-05-09

  14:17

  srussell

  7

  22-05-09

  14:17

  srussell

  Please make sure you always know which data you are processi

  my xsd:-

• John_Hill

  Ten Centuries

  Points: 1173

  More actions

  June 16, 2015 at 1:40 pm

  #1805873

  Patrick,

  I know it's been a long time since this post, but did you find a solution? I'm experiencing the same issue.