To keep things really simple, I would create a simple SSIS package. That way I could schedule it to fire when needed, or even have it fire manually from within SSMS, or even from a web page.

No need to get too deep with it, that is exactly what ETL, and SSIS are designed to do.

Andrew SQLDBA