* Extract data from operational systems and copy to staging database
* Cleanse / scrub data to make it consistent
* Load data into the data warehouse
* SQL Server tools you can use:
- TRANSACT-SQL
- Data transformation Services (DTS)
- bcp
- Distributed Queries