Review Technical ETL process for knowledge management
Kimball Group books are great source of DW knowledge and ETL information in particular.

http://www.kimballgroup.com/html/booksMDWTtools.html

Follow this link, click Tools and Utilities, scroll to Chapter 7 — Design and Develop the ETL System.

Download Sample SSIS packages contains full solutions for Adventure Works.