problem with XML Input Stage
Posted: Tue Mar 02, 2010 6:17 pm
Hi,
I had an XML document. I'm using folder stage to read data from XML and parasing to the XML input stage but I'm getting below warining in my job
: XML input document parsing failed. Reason: Xalan fatal error (publicId: , systemId: , line: 2, column: 96333757): The input ended before all started tags were ended. Last tag started was 'directory'
I had XML data as below
<?xml version="1.0" encoding="UTF-8" ?>
<directory>
<customer name="Acme" zone="Midwest">
<division>Chemical</division>
<city>St. Louis</city>
</customer>
</directory>
and In XML input stage OutPut tab columns tab I defined
ROOT_ID varchar (255) Nullable /directory
Division Varchar(20) Nullable /directory/division/text()
CITY varchar(18) Nullable /directory/city/text()
I don't know if I'm doing any thing wrong in my XML input stage. Correct me if I'm doing some thing wrong.
Thanks,
Raju
I had an XML document. I'm using folder stage to read data from XML and parasing to the XML input stage but I'm getting below warining in my job
: XML input document parsing failed. Reason: Xalan fatal error (publicId: , systemId: , line: 2, column: 96333757): The input ended before all started tags were ended. Last tag started was 'directory'
I had XML data as below
<?xml version="1.0" encoding="UTF-8" ?>
<directory>
<customer name="Acme" zone="Midwest">
<division>Chemical</division>
<city>St. Louis</city>
</customer>
</directory>
and In XML input stage OutPut tab columns tab I defined
ROOT_ID varchar (255) Nullable /directory
Division Varchar(20) Nullable /directory/division/text()
CITY varchar(18) Nullable /directory/city/text()
I don't know if I'm doing any thing wrong in my XML input stage. Correct me if I'm doing some thing wrong.
Thanks,
Raju