• You might want to take a look at Andy Leonard's blog on creating frameworks for SSIS.

    http://sqlbits.com/Sessions/Event9/Designing_an_SSIS_Framework

    You could also take a look at this book. Chapter 2 has a very good section on building a framework with a lot of logging

    http://www.amazon.com/Microsoft-Server-2008-Integration-Services/dp/0470525762/ref=sr_1_1?ie=UTF8&qid=1361458550&sr=8-1&keywords=ssis+problem+design+solution