XML Input server job finished with no output
Posted: Fri May 07, 2010 12:47 pm
I have a Server job to read XML file and write into sequential file.
The issue is, the job finishes successfully with no output.
Is there any option i need to change in the XMLInput stage?
XML Input file
----------------
<?xml version="1.0"?>
<customers>
<customer id="55000">
<name>Charter Group</name>
<address>
<street>100 Main</street>
<city>Framingham</city>
<state>MA</state>
<zip>01701</zip>
</address>
<address>
<street>720 Prospect</street>
<city>Framingham</city>
<state>MA</state>
<zip>01701</zip>
</address>
<address>
<street>120 Ridge</street>
<state>MA</state>
<zip>01760</zip>
</address>
</customer>
</customers>
XMAP (In the Description of the column definition)
----------------------------------------------------------
/customers/customer/@id (Note: this is set as the key field)
/customers/customer/name/text()
/customers/customer/address/street/text()
/customers/customer/address/city/text()
/customers/customer/address/state/text()
/customers/customer/address/zip/text()
NAMESPACE Declaration (Loaded from the table definition of the XMAP)
----------------------------
xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/"
The issue is, the job finishes successfully with no output.
Is there any option i need to change in the XMLInput stage?
XML Input file
----------------
<?xml version="1.0"?>
<customers>
<customer id="55000">
<name>Charter Group</name>
<address>
<street>100 Main</street>
<city>Framingham</city>
<state>MA</state>
<zip>01701</zip>
</address>
<address>
<street>720 Prospect</street>
<city>Framingham</city>
<state>MA</state>
<zip>01701</zip>
</address>
<address>
<street>120 Ridge</street>
<state>MA</state>
<zip>01760</zip>
</address>
</customer>
</customers>
XMAP (In the Description of the column definition)
----------------------------------------------------------
/customers/customer/@id (Note: this is set as the key field)
/customers/customer/name/text()
/customers/customer/address/street/text()
/customers/customer/address/city/text()
/customers/customer/address/state/text()
/customers/customer/address/zip/text()
NAMESPACE Declaration (Loaded from the table definition of the XMAP)
----------------------------
xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/"