Great post..Is it possible to share the ssis package. I have the same requirment and would like to experiment with it.

In our case source could be Flat files/RDBMs

KApil