Solved

Error in Data Flow Task [XML Data Source]

Posted on 2010-11-29
9
585 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 

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
 
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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Can I skip a node in XML? 9 35
SSRS 2008 Spanish Translation 8 26
Database Owner 3 21
Enabling flash installation using GPO 2 18
Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

733 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