Thanks for the suggestions. I have reduced the size about as much as I can to get any form of meaningful result (e.g. 1 of 23 sites and 1 of 6 measures). I can create and run the extract in SSRS but do not have a good handle on being able to run and export automatically using SSIS and execute on schedule using SSMS agent.

Would you have any suggestions on where I can find guidance on that approach?