p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/)
-   BOOK: Professional Microsoft SQL Server 2014 Integration Services (http://p2p.wrox.com/book-professional-microsoft-sql-server-2014-integration-services-764/)
-   -   XML error in files for Ch 3 XML validation exercise (http://p2p.wrox.com/book-professional-microsoft-sql-server-2014-integration-services/99551-xml-error-files-ch-3-xml-validation-exercise.html)

cheltzel June 13th, 2017 10:38 AM

XML error in files for Ch 3 XML validation exercise
 
I was trying to do the first part of the XML validation task exercise in Chapter 3. Using the all good XML input. I kept getting the following error in the validation task:

There is no Unicode byte order mark. Cannot switch to Unicode.

I tried several things including the encoding="utf-16" in the xml version in the XSD file. I tried utf-8 as well. The only thing that worked was removing the encoding="utf-16" from the input XML files.

Running on SQL Server 2016 using the SQL 17 CTP SSDT.


All times are GMT -4. The time now is 10:55 PM.

Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
2013 John Wiley & Sons, Inc.