Lowell,
I was hoping I could do this all in .NET managed code using some Microsoft.SqlServer.Management namespace. But I guess it is either not possible or way too complicated to achieve.
You have been great help. I thank you for all your time and suggestions. I will try to build on your suggestions into my application.
Babu.