Solved

Error in Data Flow Task [XML Data Source]

Posted on 2010-11-29
9
586 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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 

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

Comparison of Amazon Drive, Google Drive, OneDrive

What is Best for Backup: Amazon Drive, Google Drive or MS OneDrive? In this free whitepaper we look at their performance, pricing, and platform availability to help you decide which cloud drive is right for your situation. Download and read the results of our testing for free!

Question has a verified solution.

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

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software, including Percona Server for MySQL (https://www.percona.com/software/mysql-database/percona-server) and MongoDB (https://www.percona.com/software/mongo-…
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …

691 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