DSXchange

Heavy, heavy emphasis on the "If nothing else has changed in the interim" part.

Actually, please don't start a new thread, you've got too many of them on this one already. Like this doozy where the compile problem is the fact that it can't get exclusive access to the executable. Jumping on to other people's unrelated compiler issues isn't helping.

I should have been more specific... or is that less specific? I was lumping those into a generic "files" category but I think the work "flat" slipped out in the process, damn fingers. You are correct once again, Professor Moriarty.

It's not needed for Windows, only UNIX. Establish any environment variables in the normal place for Windows.

A filesystem level backup of the entire server? No, I don't believe so, not just those few jobs. If you had an export of your projects, then yes and that is what Andy was referring to, I'd wager.

You won't be able to upgrade with damaged projects, as far as I know. I would think you should be getting them "undamaged" first, that or perform a fresh install and import whatever most recent undamaged versions of your projects that you have.

Good to know, I don't recall ever hearing that before this. :D

And while I understand what the "Oracle plug-ins" are, I'm not quite sure exactly what is meant by "Oracle operators" Andy - can you clarify?

Very nice. Thanks for posting that.

This is version 7, not 8 so the path is not quite so 'complex'. Simplest solution is to cd to the $DSHOME/bin directory and run dsjob with a "dot slash" in front of it:

./dsjob -ljobs etc etc

Sorry, I would help if I could but I can't... but I hate to see a post go unresponded to.

Hopefully someone who knows will be able to add something here, in the meantime have you contacted your official support provider for help?

:? You make someone self sufficient by teaching them how to help themselves. Learning how to use the documentation that is readily available is the first step in that process. Handing someone a snippet of code or syntax on a silver platter generally teaches nothing, even if it does "solve"...

Interesting that it works via the DRS stage set to Oracle, when that allegedly uses the same native drivers that an Oracle stage would use. But hey, working is working.

Please mark your post as Resolved using the button at the top of the page.

OK, thank you.

Hopefully it goes without saying which has more overhead and if all you are doing (hence my use of the word 'literally') is staging the files for later use / transformation, then flat files are the way to go. As noted, if you need to do some sort of sql operation on the data or perform joins to othe...

And the resolution was? Always helpful to post that for anyone who comes here with a similar problem in the future.