Thank you very much for your help & suggestions.

I forgot to mention earlier that few tables might not have same number of columns.

I changed my mind to accomplish my tasks using sql scripts instead of creating a SSIS package.

Therefore I created this post in a forum (i.e.SQL Server 2008 »...

This will be one-off merge.

I thought it will be a good task to learn SSIS.

Can you please guide me with the sql scripts?

Thanks!