The processes that extract data from production database, transform and load them into your DW depend on your business requirements.

See "Extracting Data from Operational Systems", "Cleansing and Transforming Data", "Loading Data into the Data Warehouse Database" in BOL to familar with the ETL concept and tools before you start.