Solved

Error in Data Flow Task [XML Data Source]

Posted on 2010-11-29
9
580 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
Comment Utility
Hi Deepak,

TRy to set  

complexType mixed="false"

currently it might be

 complexType mixed="true"

That might helps..
0
 

Author Comment

by:pawar_deepak
Comment Utility
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
Comment Utility
Hi deepak.

please try to add false
0
 

Author Comment

by:pawar_deepak
Comment Utility
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
Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

 
LVL 30

Expert Comment

by:Reza Rad
Comment Utility
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
Comment Utility
Hello Reza_rad,

I used Generate XSD...
0
 
LVL 30

Expert Comment

by:Reza Rad
Comment Utility
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
Comment Utility
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
Comment Utility
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

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Suggested Solutions

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Many times as a report developer I've been asked to display normalized data such as three rows with values Jack, Joe, and Bob as a single comma-separated string such as 'Jack, Joe, Bob', and vice versa.  Here's how to do it. 
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

771 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

12 Experts available now in Live!

Get 1:1 Help Now