Page 1 of 1

how to use XMLinput stage DS

Posted: Wed Aug 12, 2009 5:05 am
by SagarMelam
Hi All

I am trying to read XML file from DS job and tring to write its data in Sequential file but not able to write it.Can any one explain how to use the XML stages and write it into sequential file.
Thanks in advance

Regards,
Sagar Melam

Posted: Wed Aug 12, 2009 6:54 am
by chulett
Best place to start is here. Plus, oddly enough, the documentation that ships with the product. After that, best to ask specific questions or give us more than "not able to write it" to work with if you need more help.

You could also search the forums here for "XMLInput" for other discussions on the topic.

Posted: Thu Aug 13, 2009 1:19 am
by SagarMelam
Hi Craig,
Thanks a lot for the documents that you sent and one more thing is that it is working fine for Server jobs,but when it come to parallel jobs we are getting the message which i posted below in the director.

XML_Input_1,0: Warning: XML_Input_1: Xalan fatal error (publicId: , systemId: , line: 0, column: 0): An exception occurred! Type:RuntimeException, Message:The primary document entity could not be opened. Id=C:\Ascential\DataStage\Projects\test\<?xml version="1.0" encoding="UTF-8"?>

Posted: Thu Aug 13, 2009 6:37 pm
by ragasambath
SagarMelam wrote:Hi Craig,
Thanks a lot for the documents that you sent and one more thing is that it is working fine for Server jobs,but when it come to parallel jobs we are getting the message which i posted below in the director.

XML_Input_1,0: Warning: XML_Input_1: Xalan fatal error (publicId: , systemId: , line: 0, column: 0): An exception occurred! Type:RuntimeException, Message:The primary document entity could not be opened. Id=C:\Ascential\DataStage\Projects\test\<?xml version="1.0" encoding="UTF-8"?>
Hello Sagar,

It seems the input file is not valid XML file . First you validate the file in a XML editor such as Cooktop

Thanks