rdouglas66

sys.configurations does have some really good stuff in it but not what I was originally looking for. I'm trying to find somehting more like being able to query if the SSIS component is installed or BI Dev. Studio.

Rich I haven't had any luck on finding a way to query that, just had to do it the old fashion way. Look around. I haven't got back to it yet.

Good luck, cheers.