Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nsithole
Starting Member
9 Posts |
 Posted - 2013-09-28 : 23:00:38
|
| I get this error "Unable to infer the XSD from the XML file.The Xml contains multiple namespaces"I am not sure how to get around with this error.Below is how the XML file looks like.I am using BIDS 2008<?xml version="1.0" encoding="UTF-8"?><mortage><Borrowers><Borrower><BorrowerFirstName>Roy</BorrowerFirstName><BorrowerLastName>China</BorrowerLastName><BorrowerEmail>rchina@hotmail.com</BorrowerEmail><SSN>387564731</SSN><HomePhone>9723654221</HomePhone><CellPhone>3135689563</CellPhone><MaritalStatus>Divorced</MaritalStatus><DateofBirth>12/12/80</DateofBirth><CurrentCityStreetAddress>8625 Rubina Rd</CurrentCityStreetAddress><State>TX</State><Zip>75287</Zip><YearsAtThisAdress>1</YearsAtThisAdress><MonthlyIncome>9000</MonthlyIncome><Bonuses>400</Bonuses><Commission>100</Commission><RentorOwn>Rent</RentorOwn><PurposeofLoan>Education</PurposeofLoan><PropertyUsage>Land</PropertyUsage><LoanAmount>9000</LoanAmount><PurchasePrice>9000</PurchasePrice><NumberofUnits>1</NumberofUnits><PropertyCity>Ricardson</PropertyCity><PropertyState>TX</PropertyState><PropertyZip>25781</PropertyZip><Sex>Male</Sex><Ethnicity>White</Ethnicity><Race>White</Race><Co-BorrowerFirstName>Faye</Co-BorrowerFirstName><Co-BorrowerLastName>Sparks</Co-BorrowerLastName><Co-BorrowerEmail></Co-BorrowerEmail>faye@live.com<CreditCardAuthorization>Agree</CreditCardAuthorization><Checking>4000</Checking><Savings>7000</Savings><R0000</LoanAmount><PurchasePrice>8000</PurchasePrice><NumberofUnits>1</NumberofUnits><PropertyCity>Desoto</PropertyCity><PropertyState>TX</PropertyState><PropertyZip>43215</PropertyZip><Sex>Female</Sex><Ethnicity>White</Ethnicity><Race>White</Race>Noreen sithole |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-09-29 : 03:31:17
|
| the posted XML is not even well formed. Can you post full XML please?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-09-29 : 17:23:32
|
The XML you posted, again, is not well-formed. You can test whether it is well-formed easily by using the xml string in a simple query like shown below (where I have cut out a lot of your XML)declare @x xml = '<?xml version="1.0" encoding="UTF-8"?><mortage><Borrowers><Borrower></Borrower></Borrowers></mortage>'select @x; |
|
|
|
|
|
|
XML to XSD