Solved

Error in Data Flow Task [XML Data Source]

Posted on 2010-11-29
9
582 Views
Last Modified: 2012-08-13


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
0
Comment
Question by:pawar_deepak
  • 5
  • 2
  • 2
9 Comments
 
LVL 19

Expert Comment

by:Bhavesh Shah
ID: 34237344
Hi Deepak,

TRy to set  

complexType mixed="false"

currently it might be

 complexType mixed="true"

That might helps..
0
 

Author Comment

by:pawar_deepak
ID: 34241100
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
 
LVL 19

Expert Comment

by:Bhavesh Shah
ID: 34242239
Hi deepak.

please try to add false
0
 

Author Comment

by:pawar_deepak
ID: 34249906
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
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 
LVL 30

Expert Comment

by:Reza Rad
ID: 34251320
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
 

Author Comment

by:pawar_deepak
ID: 34260610
Hello Reza_rad,

I used Generate XSD...
0
 
LVL 30

Expert Comment

by:Reza Rad
ID: 34261319
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
 

Accepted Solution

by:
pawar_deepak earned 0 total points
ID: 34394304
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
 

Author Closing Comment

by:pawar_deepak
ID: 34424463
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

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now