getting error in compilation of a job where XML is used sour

shaonli · Post by **shaonli** » Mon Apr 09, 2007 12:54 pm

I am creating a new job with XMl as source.I want to pupulate XMl source in a table.I have used xml stage and I have loaded the metadata with XML metadata importer.When I am compling the job it is giving the error

"Plug in stage does not have the required stream inputs".

I have given the XML file name in the document type tab of document settings of XML_Output stage.
But I am geeting this error.

Please suggest.

chulett · Post by **chulett** » Mon Apr 09, 2007 1:40 pm

Job design? When you put your XML source into a database table, is that flattened or still as XML?

Typical job design would look like:

Folder -> XML Input -> Transformer -> DB

For the former (flattened data).

shaonli · Post by **shaonli** » Mon Apr 09, 2007 2:14 pm

Is it is in job design.I want to load it into oracle table not in xml format.
Are you talking about folder stage?How should I use that before Xml-Input?

chulett · Post by **chulett** » Mon Apr 09, 2007 2:33 pm

Yes, the Folder Stage - that is the missing 'required input stream' the compiler is complaining about.

Have you read the XML PACK Designer Guide pdf that you have? There is a section there called 'Adding an XML Input Stage to Your Server Job' that might help. You should also find any post by kduke and go to his website from the link in his sig. There is an XML Best Practices document there you can download that is quite educational.

shaonli · Post by **shaonli** » Mon Apr 09, 2007 3:15 pm

Thanks a lot..