So, I guess the short answer is whatever will work best and get the job done.  I’m open to whatever and any examples would be greatly appreciated.

Thanks, indefinitely thought of SSIS but, dating myself for sure, I could have easily done this in DTS but my SSIS skills are pretty much non-existent.  Willing and need to...