Got it. Thanks Steve! You saved me the embarrassment of asking for the code 🙂

I'm not sure I understand the penalty of using local vars in the trigger. Why...

Trigger it is then. Thanks

In this particular case, I'm trying to work around frozen code.

AWESOME! This is not the first problem you've solved for me Jeff. Thank you! This is absolutely the best SQL Server forum out there thanks to people like you. I...

Thanks Jeff. I should have cleaned that sample crap up. Sorry. Here's some TSQL that creates more realistic data. The idea here is I need a query that will return...

Yea, that's what I need alright. In my situation, it looks like I would essentially create my month counters in the same way the PIVOT example creates the employeeId counters....

Perfect. Thank you.

Got, works great! Thanks for your patience!

I thought I understood what you meant regarding "setting the package level variables", but now that I'm working on it, I'm confused. Doesn't that leave me right back where I...

Great, thanks. That makes sense.

One more thing, how can I get BIDS to stop trying to validate my dang dynamic connection at design time. Very annoying. It does not need...

Thanks! Got it, that makes sense, but then how do I set these values at run time during each iteration of the loop? The config data is only loaded once,...

Good luck! Definitely interested in hearing the fix should you come across one.

... and trust me. Spend the hour or two figuring out how to configure connections from a config file or table. Then forget that "Save sensitive data ... user key"...

Well I think you just hit the nail on the head. "SQL Agent account is different". Permissions have absolutely nothing to do with it. That's what kept tripping me up...

Actually, this error does not look like the dreaded unattended execution problem. This error looks like it's specific to the send mail task. Maybe you could try getting just the...

Sorry, I was distracted by work the last couple days. I hope you solved your problem by now and you already know this:

Just to be clear, it's not the package...