For this I would recommend you to use SSIS package. You can easily create a SSIS package for this purpose.

Search in SQL server Central, you may get a package ready (depends on ur luck).

Its really easy to create these kind of packages in SSIS.

Its bit difficult to achieve this goal using only SQL SERVER