Link to home
Start Free TrialLog in
Avatar of jsrams
jsrams

asked on

SQL SERVER SP --> XML OUTPUT -->USE VB.NET --> MULTI LANGUAGE XML CREATION

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.

So, gurus:
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.

Thanks, VP
ASKER CERTIFIED SOLUTION
Avatar of rdcpro
rdcpro
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial