The StreamInsight installation page http://msdn.microsoft.com/en-us/library/ee378749.aspx says it's installed using an MSI package, so perhaps use a detect-only Upgrade-table item that checks for the product code? Or a system search for some other artifact of that installer?
