DSXchange

I'm fairly certain it can't be done up to version 7.5. I can't think of any way to do it in version 8 either - there's no capacity, for example, to make the Rule Set a job parameter. Of course, if there were a finite (and small) number of possible Rule Sets that you wanted to use, then a job that us...

What is occurring on the other partitions?

Will I be able to access stage variable from parallel job into this routine? Not easily. But you can write the value into a file and access that from your after-job subroutine. Or, if you want to code it, you could load the count into the job's user-status area, and access that from the after-job s...

Also I cannot see your entire message. Can you please have your entire message displayed? Certainly, by you purchasing a premium membership. For less than 30c per day you can then see the entirety of posts by the five premium posters, and have access to extra goodies for example in the Learning Cen...

Use a stage variable initialized to the partition number (or, perhaps, (next available key value + partition number)) and incrementing by partition count. There are system variables that yield these partition values.

Constrain your query so that it only returns one row. Problem solved.

For the rest of the data use a second job, that appends to the file.

You must construct all timestamps in the format that SQL Server will expect. I note that your table structure does not include a column called datetime. I also note that the timestamps specify milliseconds, which you are not providing. Finally, I note that the timestamps you are providing appear to ...

If you always want JobB to run, you can check its "do not checkpoint" check box (and recompile the job sequence).

You can change the default warning limit (for all jobs) in Director. Find Options on the Tools menu.

Better would be to eliminate the cause of the 50 warnings.

Use an after-job subroutine or a job sequence with a following Routine activity, and have the job write its output to a temporary file. If the record counts match, move the file to its new location. If not, send email and delete temporary file.

In the parallel Sequential File stage the "First line is header rows" property is a General property, not a Format property. On the Properties tab you will find it in the Options folder.

You might also like to provide information about what IIF and REPLACECHR actually do. They are not DataStage functions. (We can guess what LENGTH does.)

It depends how efficiently the validations are being performed. So the answer can only be a definite "maybe".

It depends how efficiently the validations are being performed. So the answer can only be a definite "maybe".

Nothing happening is always a tough one to diagnose. Are there any processes running that have DSD.RUN or DSD.StageRun in the command being executed? These will be job or Transformer stage programs respectively. If they are not there, the job processes may have been killed somehow, without getting t...