DSXchange

Worst case you could always post your routine for us to examine and offer opinions on.

So... it works but still says "uri is having invalid syntax"?

I don't think Vista has ever been a supported platform, so you may be on your own but have you involved your official support provider?

FTP uses port 21, SFTP uses 115. Silly question, perhaps, but are you running the version of the stage that officially supports secure ftp?

What actual error did you get? Is your dblink setup properly between the two instances? Meaning can you run your first query from Toad connected to GWH22?

"We did some cleanup"? Can you tell us what you decided was ok to delete? Regardless, it sounds like too much was removed and it's time to start looking into restoring a backup but I'd still be curious if you kept track of what you deleted.

Did you try convert?

Or if you cd'd to the bin directory then you could use "dot slash":
Or you could update your $PATH to include that bin directory and then it wouldn't matter where you were when you launched the command.

All target OCI stages? If that's the case then your upserts don't seem to be the issue, the hashed lookups are. You said that 'cached writes' were enabled, which doesn't make sense with the design you've posted - did you mean cached reads?

Not sure why he asked about 'one and the other', but you misunderstood Ray's response. Regardless, might still be helpful to answer his question. Or not.

Of course you would extend that to include all possible characters. And, of course, anything 'scrambled' like that can be easily unscrambled.

Did you let the Stored Procedure stage generate the SQL or did you do it manually? It will build the anonymous block that is needed, hence the question.

Vincent?

(ok, or Ernie)

More details, please. What stages are you using? Database? User defined sql or generated?

The Server Merge stage uses hashed files under the covers to do the actual work, so size would very well be the issue. How 'wide' are your records?