Update: I built the original version of this solution in 2010, but I am updating the solution  with SSDT 2012. This is an entire  BI solution on Chinook sample database using SSIS, SSAS, and SSRS. Credits: Enterprise SSIS Framework has been used to implement the ETL componments in this soluiton. Please find Source Code here.