Can't you use the etl tool (DTS) that come with SQL Server? It is very flexible and you can also schedule the loads.

HTH
Christian