Thanks a lot.. thanks for the detailed PDF with screenshots.

Could you please guide me on how to run this query against an specific server through SSRS. Ie., I need to select the Servername (datasouce) on SSRS and pass that value to this SSIS package and then the package should collect the data for that particular server and store the data to a table. From there the data should be displayed in a Report format.

Please guide me on the above approach or if anyother way to get it done.

Thanks in advance.:-)