SQL Server has a tool that would do that for you. It's called DATA TRANSFORMATION SERVICES. Very powerful imho.

So if you have the SQL SERVER MANAGER installed, you can use this to IMPORT/EXPORT different types of data IN and OUT of your SQL Server.