DSXchange

That looks like the old style 'Grid View' that you can (used to be able to?) get by right-clicking on the stage. Did this change on you? If not then perhaps the installation of the plug-in went a little sideways.

So... which of these two is your "desired" output:

Actual O/P
Present O/P

Guessing the first (Actual) is what you desire and the second (Present) is what you are getting but would like to be sure before I lose too many brain-cells puzzling out more of this.

If that's literally all you have in the Sequence and you disable checkpoints for the routine then there's absolutely no reason to have them enabled at all.

What options do you have enabled in the Sequence job? Does the routine return something other than a zero for success or a non-zero value for failure?

Amber, would like to continue to help with this if you're still in the market for some help. If we had a clearer picture of the issue, i.e. your current design, then I would imagine we (the folks here) could help shape a better solution for you.

Sounds like the "double convert" would work for you. One such example is here.

Sorry but I'm a little lost. You have 200+ jobs... in a single Sequence job?

I was just in here typing up a question asking what you had in the Command box versus the Parameters box. :wink: Kind of looks to me like you already have the "job name in a variable": Job_Activity_0.$JobName That would feed the JobName the JobActivity stage ran to any downstream activity....

Do you have an actual issue you need help with or did you just decide to indulge in a little thread necromancy today?

I'll have to ponder this to see if there is a more elegant solution out there, hopefully others will chime in as well. Off the top of my head you could 'brute force' it by handling all 150 columns, it will just be a little tedious to set up but won't affect performance. And best to use a Server job ...

Except for the fields per row changing, this is a simple aggregation exercise. Set a count to 0 for null and 1 for not null and sum them. Do you know the maximum number of fields that could show up?

Why are your compiler options different in the two environments? Check the lines that start with "##E", those are your fatal errors.

http://www.raywurlod.com/

Link at the bottom of the page.