DSXchange

Pls post in the right forum.
If you need to call just the executable, write a Batch (*.bat) file and call that using ExecuteCommand Activity.

By any chance, were you running the job in Multiple instance which targets the same file as target at the same time?

Do you get any error if you disable APT_NO_JOBMON by setting it TRUE?

So now we should open a ticket for Webmaster to fix it up.

Hope you are using single space " " to check the count of delimiter.

If the same jobs runs if the Sequential file is replace by Other stage, would reveal the fact that the tnsnames had that entry in the file.
Need to check, whats mystery with the earlier design.

Could you post the same here.

Else to make it more clear assign each expression in individual Stage variable and concatinate the variables. vStageVar1 =? If Write_Reversal.END_USER_NAME<> Read_SpaChannelHistory.END_USER_NAME Then 'AOO |' Else '' VStrageVar2 => If Write_Reversal.CHANNEL_FLAG<> Read_SpaChannelHistory.CHANNEL_FLAG ...

Have the input in coloumn, and the Field after TRIM in another column and the count of the Delimiter in other column. This way you can easily find the actual issue.

I guess, this is a reply to Roy.

Dont you get any ORA error code. As noted you cannot send Null to not nullable field.

Or you can get the warning message to promote to Fatal. But may not be sure of, if can handle all the types of warnings and errors.

If you need to capture all the rejected rows, you need to run the job fully with out aborting it in between.
Else "Else abort after n Row" should be the simple approach.

You need to check the input for that particular record or post it here for analysis.
So do you mean, that there are some records with single delimiter??

Approach 2 and 3 could be simple to construct.
3rd option is more configurable. You can edit the lookup data as per you changing requirement.