DSXchange

Okay... it's been awhile but... Have you actually implemented both of these and they behaved as noted or are these strictly theoretical questions / statements? Unless something has changed, last I knew only the UV and ODBC stages allowed multiple records to be returned from a Server lookup - and you...

Are you certain it's actually performing a direct path bulk load? Without that specified and without meeting all requirements, sqlldr does conventional inserts.

Yes, that's me... the rambler. :D

Sure, there is such a mechanism here as well. Problem is it's not relevant to my work.

There's a small echo in here, it would seem.

Sorry, missed the first "OUT".

I'd suggest you start with the documentation for the stage. Make sure you scroll down to see the other sections like how the Parameters tab works.

Basically you have a stored procedure with four input and one output parameters and your anonymous block includes none of them.

That's a pretty basic "validation", it would typically include validation of both values together. However... 0 is false and that 1 (actually any non-zero value) is true but is not necessarily intuitively obvious. You really should be using @FALSE and @TRUE, that or ditch the whole if-then...

Yup, there is one "off network" station on the floor but it is only for certain specific functions that require that, not general web surfing. Unfortunately. :wink: And our government issue laptops are locked down pretty tight... USB ports blocked, drives encrypted, some work must be done ...

Still applicable in an RCP scenario, though?

Ah well, gone are the days of midday help from my Government laptop. As of today I get the huge dreaded eagle laden BLOCKED page with a note that says the reason is "Outdated PHP".

Maybe someday outdated no more...

What stage are you using? How is it configured? I'd also be curious if your target table is actually "bulk loadable"... primarily that it has no indexes.

Not really sure what one has to do with the other but here you go, busted out into your own post. Had to guess at the version (etc) feel free to edit them if need be.

It's been a long time but from what I recall it needs the xsd in order to have a clue how to "validate" the xml. It might depends on what that means to the OP as simply checking to see if it is well-formed doesn't need it but would need to happen before something tries to process it or the...

Right... isn't the "cloud based system" just another UNIX box?