asked on

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.

Bhavesh Shah

Hi Deepak,

TRy to set

complexType mixed="false"

currently it might be

complexType mixed="true"

That might helps..

pawar_deepak

ASKER

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?

Bhavesh Shah

Hi deepak.

please try to add false

pawar_deepak

ASKER

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

Reza Rad

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?

pawar_deepak

ASKER

Hello Reza_rad,

I used Generate XSD...

Reza Rad

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?

ASKER CERTIFIED SOLUTION

pawar_deepak

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

pawar_deepak

ASKER

Didn't get solution to my problem but I found "XML Spy" tool to convert XML to any database table.. It worked for me.