Thanks for responding ASAP.
I was able to access the Servername using the connection manager programatically(not able to retrieve the datasource info programatically)...however i have noticed in the designer that the ServerName and the Datasource are the same.Is my observation correct?
Please let me know.
Thanks
Kiran