This shows a simple StreamInsight application that can leverage the different hosting models and features for StreamInsight. It is built using input and output adapters from the StreamInsight Samples and a custom host application. The host application shows how to use:
Different options can be configured in the application config file
More information on this can be found on my blog.
 
Update 3/9/2012: Fix for a known StreamInsight 1.2 bug (see this post) and added Sql Server Ouput adapter sample, revised to shut down correctly (see this post).