Hi XML Gurus,
We have a situation here. We have the SP from SQL SERVER 2000 to create the XML OUTPUT. THis contains multiple orders (one order to many lines);
We are using a VB.NET program to read this as a stream and create individual XMLs based upon the order. ie., One XML file per order that has many lines.
Exmaple: If there are 10 orders with many lines, it will create 10 different XML files.
We have the perfect UTF-8 output file from the SP. NO issues here. We can take output in a text format (OEM method) and view it in IE or MS WORD and successfully see the Japanese characters.
However, we just cannot reanme this file to XML as it throws an error . We tried with UTF8 encoding too; no luck.
1) Do we need to convert this text file taken out from the SQL SERVER 2000 via DTS package (OEM method)?
2) Does the VB.NET program need any special comonenents require for this?.
Someone in the forum has suggested to look into http://www.chilkatsoft.com/ChilkatCharset.asp
to convert from a Text file to XML.
Will this work?.
OR is there any other suggestions?.
Pl. help us out.