tutorials or url on how to design an etl that loads data in Dimension table in sql 2008 r2

How can design an ETL that is able to load new records in dimension table and automically primary keys or surrogate keys are assigned to new record开发者_运维问答s in a dimension table. Please help with Tutorial or explanations on how to insert records in a dimension table and primary keys are being inserted automatically??I am using SQL 2008 r 2

---

Todd McDermid is wicked smart, assuming you're using the DimensionMergeSCD component

SQLServerPedia has a lightweight article

Jork Klein has a nice series using the SCD wizard

Brian Knight has a video on it if you're into that sort of thing

Karan Gulati has a post as well