I expected it would be a simple answer (foolish, I know).

So here is an example of what I have to work with.

An example of a view where all the functions...

All great questions and I hope to get back to this sometime this week, but my priorities change nearly every hour and right now I have balance this with 2...

Thanks Phil,  Having that done in JAVA is out of my control.

Never like continuous jobs, not even those that run every 10 minutes, which is how often this would be...

Sounds like a great idea, thanks Jeff.

I've never used synonyms, this should be fun 🙂

I said script task when I meant script component.
I love your idea of precedence expression constraints to control the flow.
I do have the 2 nearly identical data flows.

AH!!

hmmm - Copied this from MS DOCS

General Remarks

That I do see, actually I see it in the Template selection list under new session wizzard.
Thank you.

Thank you Sue.  I don't see that in SSMS 2017 on SQL 2016Ent.

Thanks Steve,  Extended Events is what I just started looking into.

I understand that would be the best way to do this, however, I can't do that.  Let me try to rephrase my question.
Are there any system tables that capture...

Very interesting, but again it gets me thinking - I hate when that happens.... 🙂
What is the difference between these 2 variations of today's QOD and how would you...