Error in Data Flow Task [XML Data Source]



Hi,

I have an XML file which I want to use as a Data Source to generate a report but he XML file has a complex data collected from different data sources. So I cannot use this file directly as a Data Source.

I was trying to convert this file to SQL Server Tables using SSIS but I got the above error.

Is there anyway, I can convert or break XML file into SQL Server Tables or simplify it so that it can be used to generate a report?


Thank you. Error Screenshot
pawar_deepakAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
pawar_deepakConnect With a Mentor Author Commented:
Didn't get solution to my problem but I found "XML Spy" tool to convert XML to any database table.. It worked for me.

Thanks.
0
 
Bhavesh ShahLead AnalysistCommented:
Hi Deepak,

TRy to set  

complexType mixed="false"

currently it might be

 complexType mixed="true"

That might helps..
0
 
pawar_deepakAuthor Commented:
Hi Brichsoft,

Thanks for your reply. But I don't have "complexType mixed" in my XML file.

Should I add "complexType mixed="false"" in the file?
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
Bhavesh ShahLead AnalysistCommented:
Hi deepak.

please try to add false
0
 
pawar_deepakAuthor Commented:
Hello Brichsoft,

It didn't work. It's giving me same error.

I am attaching sample XML file. It contains records of students and I need to generate Transcript(Report) from the data. In the file there is information for 2 students and their grades. I have 100s of students listed in original file.
MASTER-GRADE.xml
0
 
Reza RadConsultant, TrainerCommented:
when I try with your XML file there is no error on XML source,
did you used Generate XSD ? or you used an existing XSD?

0
 
pawar_deepakAuthor Commented:
Hello Reza_rad,

I used Generate XSD...
0
 
Reza RadConsultant, TrainerCommented:
but when I tried with the xml file you uploaded here and also used Generate XSD button, no errors appeared, just warnings....
are you sure that the file you uploaded here is exactly what you have problem with it?
0
 
pawar_deepakAuthor Commented:
Didn't get solution to my problem but I found "XML Spy" tool to convert XML to any database table.. It worked for me.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.