QTI Import
QTI Import
I need help regarding QTI import.
We at Fulton county schools looking forward to import data into our datawarehouse which we will be receiving from one of our vendor in QTI format in near future and before that I was trying couple of samples provided at:
https://www.imsglobal.org/question/qtiv2p2/imsqti_v2p2_impl.html#3.4
I am using SSIS to import these xml files which worked fine for choice_Multiple and order xml but choice xml is throwing error :
“the xml source adapter does not support mixed content model on complex types”
I am not sure what is the difference between choice and other choice_multiple and order xml samples as they worked fine and they are complex type too.
SSIS Issue
Without more specific detail it is difficult to give a definitive answer.
I think the phrase 'complex type' refers to the QTI XSD which contains several XSD complexType definitions that permit both child elements and text i.e. mixed content.
Therefore, the problem is with the SSIS import/validation of XML and not the examples.
SSIS error message
I think Colin is right; this is a SSIS error message.
For more info on the message, please view this topic on SQL Server Central Forum.
Thanks,
Mark.
The only difference I see is
XML Import
Thanks for replying!!!
It worked after removing image but even extended_text.xml didn't work so I am thinking I am getting error because of image. Since some test questions are supposed to include image can you suggest some way to handle that?