An update can be just as bad as a delete statement(potentially worse since a mass delete is likely to be immediately noticed a mass update might screw things up for...

Well do you name all your jobs with unique identifiers?

I'm also seeing a ton of things like this PARTY_ID > 0 in statements that are creating temp tables.  Is that an identity field?  If so aren't you basically just selecting...

I always find it mind boggling that companies are willing to pay 7 figure software licensing costs but then get stingy about a few hundred dollars worth of RAM.

There are several ways to do that, is the format of the data the same?  One option is to use a union in the same data flow and join the...