Click here to Skip to main content
14,549,334 members
Rate this:
Please Sign up or sign in to vote.
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 6:14am

1 solution

Rate this:
Please Sign up or sign in to vote.

Solution 1

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 ...
   
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, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100