I assume that you can't use linked servers as you mentioned storing SQL logins in a table. Is this the case or are you able to setup linked servers to access the index stats?
This is important as I don't want to go down the SSIS route if there is an easier alternative to implement.
By the way, can I suggest you Google for Rodney Landrum's DBA Repository and SQL-uation DBA Repository. These are two great solutions for gathering information from SQL instances in a trusted/non-trusted domain.
Although I didn't use their solution, I studied the code and SSIS packages and was able to customise my own solution.
---------------------------------------------------------
It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]
Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn