>>>Hi Kevin,
>>>I think you caught my misunderstanding of the views. I should have said that I am looking for a way to extract the data into a view daily. But since I posted my questions and based on the input and/or questions of others, I see that I could do what I need right from the data table, without a view. I am working on testing my "approach".
>>
>>OK....Actually, Craig's response is ideally the best approach. A basic SSIS package that writes out data with a specific output name as a job. Yes, I realize there's a learning curve, but SSIS is such a powerful tool that it's often worth the learning curve.
>
>I will look for a newbie tutorial for SSIS. Thank you.

These videos are dated, but a good start. I built these to supplement the courses I taught.


http://kevin_s_goff.typepad.com/setfocusadditionalbi/ssis-1/