Just to add an update to this, SSIS 2016 now has an ODBC Source which is found in the "Common" grouping in the SSIS toolbox 🙂 Don't forget that SSDDT...

Michael Meierruth (2/25/2016)

---

Maybe the birth of hadoop was motivated by the Netflix contest back in 2006.

I drove into this contest with immense passion and I remember doing lots of things...

nick.dale.burns (12/7/2015)

---

Hi Barnaby, thank you for putting it all together in one script. I think you have pretty much answered everyone's questions in one great post! 🙂 Do you think...

kevin 19285 (12/7/2015)

---

I'm brand new to R and not really sure what I was doing, but I was able to make it through this with a new install of RevolutionROpen...

Full working code to directly query the server. Just fix the connection string for your environment 🙂

install.packages("ggplot2")

library(ggplot2)

install.packages("reshape2")

library("reshape2", lib.loc="~/R/win-library/3.2")

install.packages("RODBC")

library("RODBC", lib.loc="~/R/win-library/3.2")

#load data

query <- "select

object_name(ops.object_id) ...

My area of improvement next year is to improve my skills in the BI sector. I am going on the MCTS BI course in January and hope to continue my...