Click here to Skip to main content
15,559,122 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi
I am trying to learn how to load an XML (XML source) into SSIS 2010 , the data will then go to an SQL Server 2012 Table.

The issue I am having, Is I am trying to follow a tutorial, and I am getting the same error:

The XML Source was unable to read the XML data. Data at the root level is invalid. Line 1, position 1.

This when downloading any of the tables - the one I have chosen is region.

The trail site is http://api.worldbank.org/countries

I have tried changing the top line



with no success. Please help

Here is the beginning of the script script - this is in an XSD file


<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xs:element name="countries">
<xs:complextype>
<xs:sequence>

What I have tried:

I have tried changing the top line
Posted
Updated 11-Aug-19 7:14am

1 solution

So go back to the "trail site" and ask there: they wrote the software, they made the tutorial, they provided the XML (I assume).

They know their product: we don't. So the place to ask is the place you found it!
And if they don't reply, or can't fix it ... at least you know just how useful their tutorials actually are ...
 
Share this answer
 
Comments
Joanna Webster 11-Aug-19 12:22pm    
hi, the tutorial was from years ago.. i am having the same issue to be honest with other XSD schemas i have tried from W3schools .. same error message. please help
OriginalGriff 11-Aug-19 12:27pm    
So cut down a copy of the XML file to the minimum, and if that still fails then manually compare it with a known working one.

It's either the code (likely) or the XML itself (less likely if it's the header) so find out which!

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900