I'm trying to get DataStage to read an XML file and use a custom XSL file to transform the XML before it passes it to the DataStage Transformer. I have been able to get Datastage to read an XML file and write it to a Relational DB.
When I add in the XSL file (Advanced tab of XML Input object), I receive the following errors (repeately) when I run the Server job:
i:95fafa19cfload_xml_certificate_crosswalk..XML_Input_1: XSLT Processor: Unknown element on the output. Element Name = "ROWSET"
load_xml_certificate_crosswalk..XML_Input_1: XSLT Processor: Text can only occur as a direct child of a "column" element.[/i:95fafa19cf]
I'm not sure why the XSLT processor is giving me these errors since I have test the XSL process outside of Datastage and it works fine (using both XMLSpy and the Microsoft XML processor).
I'm using Datastage Designer 7.1.
Any and all help is appreciated.
Pinned topic Problems trying to get XML Input to use a XSL file
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2006-02-09T14:04:29Z at 2006-02-09T14:04:29Z by SystemAdmin
Re: Problems trying to get XML Input to use a XSL file2006-02-08T17:46:43ZThis is the accepted answer. This is the accepted answer.Experiencing the same problem. I am trying to create an XSD (XML schema) for subsequent target mappings - it consistently reports XSLT processing errors - unknown element name 'xs:element'.
IBM Support - is there guidance/documents using custom XSLT's, e.g. is there an expected format to use?