how to use XMLinput stage DS

SagarMelam · Post by **SagarMelam** » Wed Aug 12, 2009 5:05 am

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

chulett · Post by **chulett** » Wed Aug 12, 2009 6:54 am

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.

SagarMelam · Post by **SagarMelam** » Thu Aug 13, 2009 1:19 am

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"?>

ragasambath · Post by **ragasambath** » Thu Aug 13, 2009 6:37 pm

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