Thanks for the quick response, but my company will never allow a trigger in master.

Do you know of any SQL 3rd party tools that handle something like this?

Hi Phil,

Nice to hear from you. We are actually waiting for approval on this, but for now I am looking for something quick and dirty.

Thanks for your responses as usual....

Thanks very much for the baseline!

I see your point, anything is possible during an SP upgrade, but this gives me a great starting point.

Awesome, thank you!

Hi Chris,

Thank you for your quick response. Yes, we have all of that. Lastmodified, Startdate, Enddate, etc. It seems that this is the best method. I am in the process...

Hi Phil,

I am waiting on access to TFS, so yeah, it would be great if I could just grab the package itself. They only provided me with the...

Thank you all for your responses. I think I am going to avoid the MERGE 🙂

Yeah, that's what they did initially and it was killing performance. Production has millions of rows.

My task is to optimize this because everything gets UPDATED regardless if there...

Thanks Phil. It's funny, I assumed that would not work 🙁

Thanks Grant.

If you are in New York City, it's....

update tasks
set opendate = DATEADD(HH,-4,[opendate])

Thanks guys and it's always nice to see Phil 🙂

"Exactly how do you invoke the HARMONY web service ? If you use C# today to do so, you can do the same in a Script Task within SSIS."

That makes sense 🙂

Thank you

This solution would work, but its not realistic for my case. Most reporting environments just call the proc. This blog is talking about linked servers and Open query which is...