DSXchange

Give it a try, it's not that hard to figure out. Sounds like your first problem was because you left the Procedure Name blank, make sure you put something there.

That's an input column / link name that it can't find, not a stage variable. Check your spelling.

It's certainly possible, we call that stats package quite a bit... but typically as a target at the end of a job stream. For 'inline' stats we stick with before/after in the ORA stage but I'd wager it could be made to work your way as well.

Search. You're not the first person to have this issue.

It's a hard one to track down. Involve your DBA. Google can turn up various advices as well, for example:

http://www.orafaq.com/forum/t/46556/0/

There's no project level setting for this, or at any level for that matter. What's different about this project - it's not Protected, is it?

Oh, come on Ken - why take all the fun out of it?

Then mark the post as Resolved, please.

Don't equate using 'sudo' to a 'non-root' install, they aren't the same thing, at least not in my book. I've done root installs of 7.x Server just by getting sudo access to the installation script. So, unless someone thinks otherwise, I'd say that should suffice. No guarantees, though.

You really should just Google for stuff like this. For example:

http://www.ibm.com/developerworks/xml/l ... leatt.html

If they were proper proper it would all be working. How about posting a sample of the XML and your XPath expressions?

That's how you would do it - use a hashed file to store and lookup the current value. What's not working for you? Are you building some kind of SCD?

I did not ask if you have input and output links, but rather what columns you have in them. And make sure something is in the Syntax / Procedure Name field, even if it isn't "used" it needs something there.

Search for 'suppress', it has been mentioned several times. Freebie:

http://www.dsxchange.com/viewtopic.php?t=111199

Hard to understand what you have or don't have defined in the stage at this point. Do you have any columns in your input and output links?