DSXchange

And just post your issue once in one forum, please. No need to spread it around.

Eight years later and not the same, similar perhaps but not the same. Let's get you in your own post and make sure I have your particulars correct... version 11x on Windows, Server job, yes? How are you going to determine which of the words in your string are 'salacious' and thus need to be removed?...

Isn't there a mode that is something like 'Replace completely'? It would do a delete of any existing records before inserting the new version which may get around your issue.

sharmabhavesh wrote:Also, what all set up or configuration is required to set up FTP between 2 servers?

That's a question for your System Administrator(s). We don't know what is or isn't allowed in your organization.

Rather than post something 'like' your issue, can you post the actual, unedited message in the report that is concerning you?

TFM = Transformer, I assume.

So... you put things back the way they were?

prasson_ibm wrote:In my case data is going out so Source Stored Procedure will work.

For that to be true you'd need to get rid of the Row Generator.

The type is very straight-forward:

If data only comes out: Source
If data only goes in: Target
If data goes in and out: Transform

But it seems to me the point about considering NLS still stands in a general discussion of the function.

And would still like to see the answer to qt_ky's questions.

You would typically use an Execute Command Activity stage to run scripts in a Sequence job, it has separate properties for the command itself and the arguments that should be passed to it. See if that works more better.

LOL

(3 points!)

TonyInFrance wrote:However am I to assume that with my current setup (Oracle 11.2) I cannot get the Operations Console to run correctly at all?

I wouldn't make any such assumption quite yet. The issue in cdp's linked post was their inability to use Oracle 12c, not 11g. Have you involved support yet?

You can't just handle "{" - seems to me you'd need to handle the full range of the signed overpunch values... "A" being a positive 1, "B" positive 2, etc. And then there's the negatives. And you'd have to handle the implied decimal. Shouldn't the stage be doing that for...