>>>>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/Thank you!
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham