DSXchange

For Windows replace all /dev/null with .\NUL - there is a NUL file in every folder. Thanks for the info but I already tried that. It is not able to open that as a source file. But I'll keep looking into it. I thought if I understood what the job was attempting to do, there are likely other ways to ...

Ok, for us Windows guys who don't know much unix: Can you explain the purpose of the single_row_sc stage? All I see is that it is sourcing from /dev/null. I know what /dev/null is but don't understand its purpose as a source file here. Thanks.

I have a job that is periodically experiencing connection errors. It is never at the same time and typically happens once a day -- although it had no failures over the last three days. I'm looking for some suggestions of how to track down what might be happening. The OLE DB error is a general failur...

Yes, I tried both a negative end value and a step value of zero. It won't accept either.

The step value cannot be zero. The start value must be less than the end value if the step value is positive, or start must be less than end if the step is negative.

I'm trying to implement some continuous loop logic in a sequence. I have been successful using the Loop Activity but it uses start/step/end values and I really want to just loop until a certain clock time which is trapped by a nested condition within the loop logic. I can get it to work using very l...

Thanks. You are correct. I hadn't noticed that the parameters were listed there before.

kduke wrote:When you go to select the parameter value then right click. Choose a Activity Variable. Pick the routine you just called. You can choose $ReturnValue, $RoutineName or any argument.

7.5 server

If I undersand, you're saying that I can use a passed parameter to return a value as well. I'm not sure how you would do that in a routine activity since the only thing available is the <stage_name>.$ReturnValue. I see no way to access the passed in parameters from the stage. So maybe I'm not unders...

That was exactly what I needed. What have I learnt? 1) "routine" activities are more for doing some job and reporting back whether it succeeded or not, and 2) "user variable" activities are more for setting up variable values for use within the sequence by other stages. You got m...

I spent a while working along this line but haven't been completely successful. Even though I made the trigger a "Custom" and the expression "RUNOK Or RUNWARN", it triggers correctly but the warning still shows in the log and produces a Status = 2. The only thing I found that aff...

I can easily see how I could put something into these variables within my routine. But I haven't figured out a way to get the values out of them without using another routine. It won't accept them as an expression in the parameters passed to a job by the sequence. Can you provide any examples? Make ...

Oh, so if I make the trigger catch the warning as well as the OK (and treating them as acceptable) then the warning won't be in the log? This sounds worth checking out. Thanks. You can use the Conditional Triggers from the Routine Activities in the Job sequence. If you look at the Options, you will ...

Thank you. This sounds promising. I'll look into it. Make your routines always return 0, look at using @USER0 thru @USER4 as some alternative methods for returning values from a subroutine call. The are COMMON variables that exist out there without you knowing about them. Now you do, think about usi...

Actually, I tried several searches. The challenge is knowing what to search for. :? And I understand about the option "Automatically handle activities that fail". But you can't use this if you also have an exception handler in the sequence. We've had this conversation many times here, Rod....

I have a sequence that uses a couple of routine stages that employ custom routines to retrieve values. These values are subsequently stored in sequence/job parameters for use by several of the stages in the sequence. Unfortunately, when a routine returns anything other than zero, it causes a "d...