I have experimented with certificates and took a quick look at Power Shell and SSIS and I think SSIS is probably my best options. I found an artical on using SSIS with examples. I wants be to launch Business Intelligence Development Studio [which is basically Visual Studio] and create a new project and select Business Intelligence Projects project type. That type is not one that I have on my list. I tried installing Business Intelligence Development Studio from my SQL 2008 R2 DVD and it is still not on the list. Is this something I can install seperately as a plugin?

Never mind. I figured it out