DSXchange

Was the job already reset?
-wait will wait for the job till it finishes. Where you can even use -jobstatus, which will also wait till the job gets completed and also returns the exit code.

Is User Defined SQL used? If so what is it?

kduke wrote:I had a topic in one of the old newsletters about estimating.

Yes I could easily reacall the link.
Pls find it below.

http://www.datastagexchange.com/Newslet ... enting.htm

For this you wont be even need to include the terminator stage. Just "check Automatically handle that fail". Make the 5 job activities independent.

Vincent - Hope now by this time you are ready with another blog

Are you sure your target formated to dd-mon-yy and not as dd-mm-yyyy?

So genuine to pose even the bug in the description.

So give a sequncer the 5 input from 5 job activity. Wait till all get finished. If all pass the test, ok else 'Terminate' it.

Craig -Curious to know the way to find the number of process involved in the job by executing it in server editon.

Just have another additional column in both the file. With the value of '1'. Make a JOIN. Youcan get the cartesian product of what you expect.

Else all the active stages can be combined to a single process. Go though the document given or do a search.
Each passive stages will frame a boundary where the active stages between that will be clubbed together. Also go though the purpose of interprocess stage.

Ray has already mentiond in his post that it not possible to compare a record even before it was read or accessed. You can compare yesterday and today and not today and tomorrow. If you have read 0,1,2 and if you need to compare current and previous and current and need to compare 1 and 2 similarly ...

Not always. Actually the staticts shows both n rows as well as n rows / sec.
Both full quantity as well as the rate at which the rows been processed.

Based on the statistics,have you taken remidial action to improve the performance?

Do you need to export the metadata into a Sequential file?