Hi Ravi,

I'm traveling today and find it difficult to type or paste links from my phone. I'm old school. And old. If you browse to SQLblog.com and cluck on my blog, you can search for a post called Designing an SSIS Framework. There's a link in that post to a version of an SSIS Framework that demonstrates a serial execution pattern and centralized logging.

Hope this helps,

Andy