DSXchange

Craig, Thanks for the reply. I have tried '@NULL' instead of '@Null' and got the same error. As for an exact derivation, that is it I'm afraid, just '@Null' in the derivation column. An example of another derivation though is: If Len(Trim(Field(svContributorDetailsOut, "|", 1))) > 0 Then F...

Just to keep you up to date, I just finished replacing all the derivations in the second transformer stage to stage variables, and (shock horror!) I got exactly the same errors for the first transformer! I am just about to go and set up stage variables here so I can at least get the job to compile a...

Hi all, I have a server job which results in an Oracle table being populated by either one of two transformer stages. A large number of these output columns will default to Null. In the first transformer stage, I just set a number of these columns to @Null and use various other derivations for the r...

Craig,

Sorry for the delay but thanks a lot for your reply - works perfectly.

Cheers
Johnno

I want trigger a job in a sequence using more than one value of the UserStatus of the previous job. Can you do this? If so, would it be as simple as entering in the Expression column on the Triggers panel: =1 or = 2 or = 3 (etc..) (although it doesn't seem to like this)? Or do you have to be more sp...

Thanks a lot guys. I will have a go at doing this today and let you know the results.

Sorry guys, didn't want to confuse the issue- never mind. This job processes music played by radio stations. Table1 is our BROADCASTERS oracle table with attributes TP_SURR_ID, DN_TP_NAME, STATION_ID , GC_TRANS_TYPE_TABLE, GCTRANS_TYPE_CODE and FULL_SAMPLE. Table2 is our BROADCASTERS_SAMPLE_DATES or...

Thanks very much folks. Our intention (at least for the time being) is to send to a single recipient, so multiple addresses are not important yet.

I will try and track down some ideas on how to achieve this via routines - I think I can remember some old posts that mention this.

Thanks again

Hi all, I am trying to send an email notification (using a Notification Activity in a job sequencer) which includes a link to a report file. I though the best way to do this would be by using parameters or userstatus values to include in the email body, but this does not work. Can anyone offer any i...

Hi all, I am trying to send an email notification (using a Notification Activity in a job sequencer) which includes a link to a report file. I though the best way to do this would be by using parameters or userstatus values to include in the email body, but this does not work. Can anyone offer any i...

Hi all, I am trying to send an email notification (using a Notification Activity in a job sequencer) which includes a link to a report file. I though the best way to do this would be by using parameters or userstatus values to include in the email body, but this does not work. Can anyone offer any i...

Hi all, I am trying to send an email notification (using a Notification Activity in a job sequencer) which includes a link to a report file. I though the best way to do this would be by using parameters or userstatus values to include in the email body, but this does not work. Can anyone offer any i...

Hi all, I am trying to send an email notification (using a Notification Activity in a job sequencer) which includes a link to a report file. I though the best way to do this would be by using parameters or userstatus values to include in the email body, but this does not work. Can anyone offer any i...

Hi all, I am trying to send an email notification (using a Notification Activity in a job sequencer) which includes a link to a report file. I though the best way to do this would be by using parameters or userstatus values to include in the email body, but this does not work. Can anyone offer any i...

Hi all, I am trying to send an email notification (using a Notification Activity in a job sequencer) which includes a link to a report file. I though the best way to do this would be by using parameters or userstatus values to include in the email body, but this does not work. Can anyone offer any i...