Command line export and import CSV in SQL Server 2008 R2
Based on your need, I can suggest couple of options :


Use SSIS Import/Export; or  
Use BCP OUT and BCP IN


Each method has its own benefits and it all depends on your requirement which one to choose.