An alternative to a 24 step package would be to have a ForEach iterator walk each of the yearly values, passing the value into the dataflow to work on the...

I agree, which is why it doesn't make any sense to me as to why they would have added the WAITFOR in the first place.

Figuring I may have been missing...

Thanks Scott!

One of the primary tenets of my former team was supportability of the code, as there was no guarantee of code ownership six months+ down the line. Not only...

Good point. That looks much cleaner 🙂

Took a stab at converting your code to a simple update statement. Is there any reason the following won't work for you?

UPDATE #TEMPINVENTORYHISTORY

SET ORIGCONTAINERNO = ORIGCONTAINERNO,

SET ORIGPACKAGENO =...