DSXchange

And their names will default to Arg1, Arg2 etc but you can change that and name them appropriately if you so desire.

How do you do what - change the auto purge settings for a job? The option is there in the same place where you do a manual purge, a radio button from what I recall.

As noted, you can use the substring operators - the square brackets. There is also the Left() and Right() functions if you just need stuff from either 'end' of the string.

Add the proper $APT variable to the job (name should be obvious) and set it to True.

Server doesn't natively support an Oracle TIMESTAMP, so one would need to build them as a string in the proper format (with the correct fractional seconds) and then use the TO_TIMESTAMP() function in User-Defined SQL in the stage.

If those are in your data, then you do actually "need" them converted like that. And it is an all or nothing setting, I'm afraid.

"No such file or directory" seems pretty clear and should be the first thing to check.

Yah, you've made this way more complicated than it needs to be.

He did help. The rest is up to you... or any of the thousands of other people here could chime in as well.

How exactly are you "loading" the data into Oracle - stage, action, datatype, etc? What is the datatype in Oracle (not the job)?

Disable operator combinality and rerun the job, then you'll know the stage that is the culprit.

Also curious if you are running the job on multiple nodes or a single node?

Of course, knew someone would come along and note that.

Ah... secret handshake backdoor entrance.

Case insensitive.