You can use Data Transfomration Service of MS SQL Sever. Or use the flat files to transfer data.