DSXchange

Or you may be able to accomplish that in a Parallel job by using a Server Shared Container for that USERSTATUS portion but I'd have to leave that to others to confirm / deny...

Only via a Server job and USERSTATUS. Does your job that creates this 'output record content' really need to be a Parallel job?

That's not a "work around", that's one solution for this issue. I've already mentioned the other.

This PL/SQL, is that what you are using in the target connector in the second job? Or somewhere else? Not being able to see what you are doing makes this hard to trouble-shoot but you should be fine if you do explicit conversions and only when needed, right now it seems like you are doing both too m...

Pretty much the same thoughts. If your target is a varchar, why AsInteger? Just move it through.

And not really sure what you mean by 'dynamic SQL' in this particular case and how that would stop you from doing the conversion in the transformer... but ok.

Again, if you want to add it to the project, create a User Defined variable with that name. You could set it to $ENV and then override it in a job, or just set your other path in the project so all jobs use it, if that's what you need.

If the first job that populates the dataset converts the integer to a varchar and the Oracle target in the second job in a varchar, why does the second job need to do any 'reformatting'? Try using DecimalToString() in the first job rather than any cast / NullToEmpty / AsInteger shenanigans in the fi...

That mask of %dd says that there will always be two characters in each day number. You need to let it know there could be one or two characters. How to do that is all spelled out in the Parallel Job Developer's Guide where it lists the Date and Time format strings.

First off, that's the default location so there's no need to have $TNS_ADMIN set. Have you verified your TNS entry is correct?

Add it as a User Defined variable to the project... but adding it to dsenv should also work. Show us your syntax, you may not be exporting it.

That would depend entirely on the web service and how it was designed.

What is the data type of the target column in Oracle? In the job?

Isn't that what we're already doing in the FAQ forum? Covering 'special topics'?

And what have you tried so far? What issues did you have when you tried them?

Please don't 'Reply with quote' on everything but feel free to use it when you actually need to. Otherwise, there is a perfectly loverly Reply to topic link that just lets you simply reply and saves me having to come along behind and clean things up.

Thanks!