B
billybobsonic
Guest
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
<?xml version="1.0" encoding="UTF-8" ?>
with no success. Please help
Here is the beginning of the script - this is in an XSD file
<?xml version="1.0" encoding="UTF-8" ?> <xs:schema xmlns:xs="XML Schema">
Continue reading...
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
<?xml version="1.0" encoding="UTF-8" ?>
with no success. Please help
Here is the beginning of the script - this is in an XSD file
<?xml version="1.0" encoding="UTF-8" ?> <xs:schema xmlns:xs="XML Schema">
Continue reading...