I have a SQL 2005 database.
When a new record in a special table is inserted, then I want to SELECT some data and transfer the data via WMI to another program.

I did succeed to enter data to the program by manually executing a .vbs script (see quote below).
My idea is to use a TRIGGER in the SQL-table to start a SSIS-package that do the SELECT and transfer to WMI.

I have found in VisualStudio two WMI-controls: "WMI Data Reader Task" and "WMI Event Watcher Task" - but from the titles it do not seems as they also can "deliver" data for input by WMI to an external program?

I am new to WMI - and not expert (yet ;-) in SSIS and TRIGERS.
I will be very glad for any comments on if I am on the right path, or some other ways is more easy, stable etc.
And of course if you have any tips, tricks, links to "copy & paste" exemples etc :-)

The vbs i looking something like this:
Set wbemServices= GetObject("winmgmts:\\" & strComputer & "\root\customProgram")
Set oReg = wbemServices.Get("Lnl_IncomingEvent")
Set oMethod = oReg.Methods_.Item("SendIncomingEvent")
Set oInParam = oMethod.InParameters.SpawnInstance_()
oInParam.Source = "Location 1"
oInParam.Device= "GPS Device 1"
oInParam.Description = "Test Event From WMI"
call wbemServices.ExecMethod("Lnl_IncomingEvent", "SendIncomingEvent",oInParam)