DSXchange

Hi Gurus,

I am using XML input for the first time . I searched the forum, All of them suggested to use a external source stage with ls command. But can anyone tell me what I need to specify in the Columns and format tab of external source stage?

Any reason for not using XML source stage? You can import the metadata for the XML file from the stage. What have you searched on? ls command will give a list of files in a folder. what are you trying to do?

BugFree wrote:Any reason for not using XML source stage? You can import the metadata for the XML file from the stage. What have you searched on? ls command will give a list of files in a folder. what are you trying to do?

External Source Stage ----->XML Input Stage------>Further processing.

This is what I am doing.

Hi i am Amey

In the Source Program you specify the name of the file along with the path name.
example:
find PathName -name "Xml File Name " -print

Set the format to default values.
In the columns you specify any name to the column since it conatins only the file name along with the path.

I have used the above command, At the output of external source stage I can see the filename along with the path being passed sucessfully, But at the XML Input stage count stays at 0. What could be wrong?

When XML goes into an XML Input stage but doesn't come back out, it usually means your XPath Expressions are incorrect.

I have created a Server job for the same, I have used source as a folder stage, I was able to extract the data from the xml file. Now I am using the same xpaths in the parallel jobs, But still the problem persists.

In folder stage I have two columns viz. Filename (Varchar 25) and record (LongVarchar 999999). And in XML input stage I am using the records column to fetch the xml data.

But in PX I am mentioning only Filename. So does the XML Input Stage extract the data from the filename/filepath it gets from the external source stage???

Hi All,

I have resolved the issue, I was specfying the XMLdocument, rather than a URl path.

Thanks all for the inputs