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...

I spoke to soon. That link looks like it might work.
Thanks Jason.

Hi Chris,

Tableau doesn't support SQL Procs either :(.

I see this more and more with new technologies. They release a product that is incomplete and say...