DSXchange

There's no "attachment" option here, or a place to upload files. You can, if you like, upload a screenshot of the canvas to any of the free filesharing sites out there and then include a link to it here using the "Img" or image tags.

Define 'huge'. Ernie's website (link in sig) discusses how to use the External Source stage to feed XML Input the filename(s) for it to parse.

Job design?

It does it automatically. That's why we're confused as to the approach you're talking about. I take it you haven't worked much with XML before this?

Specifically, an exact search for "ParamValue/Limitvalue is not appropriate" is in order.

First thought - create a separate job that just calls the proc, run it after all of the load jobs complete.

"9i" isn't the version, that would be more like "9.2.0.5" or something similar. And find out both the client and database versions.

Advise you search the forums for your error. It's been asked and answered quite a number of times.

Just because it was built "separately" doesn't mean it's "not a true xml file". As Ernie notes, read it with the XML Input stage.

The error shows that you are not creating them after the last load, there is still a load going on when the sproc was called: ORA-02476: can not create index due to parallel direct load on table Cause: A parallel direct load is occurring to the specified table. Action: Retry statement after load is ...

Again, why do you think you need to do this? And are you generating this xml or trying to read it?

Post an example. There's no 'header' and 'trailer' records, per se, and removing them will break the parser, I would think. I'd also be curious why you think you need to do this.

Excited, I see.

Load your file into a work table. Join to customer and order tables. Write 'data extract' to file. Go home early.

I like how it continues the 'orchestra' theme in the product - it's the music they play.