Solved

Error in Data Flow Task [XML Data Source]

Posted on 2010-11-29
9
583 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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 

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

DevOps Toolchain Recommendations

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

Question has a verified solution.

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

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.
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

813 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