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
how to use XMLinput stage DS
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 26
- Joined: Mon Apr 21, 2008 4:03 am
- Location: Amalapuram
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.
You could also search the forums here for "XMLInput" for other discussions on the topic.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 26
- Joined: Mon Apr 21, 2008 4:03 am
- Location: Amalapuram
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"?>
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"?>
Sagar
-
- Participant
- Posts: 12
- Joined: Wed Oct 03, 2007 9:11 am
- Location: London
Hello Sagar,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"?>
It seems the input file is not valid XML file . First you validate the file in a XML editor such as Cooktop
Thanks
Regards
Raga
Raga