Launch SSIS package with SQL Event

Is it possible to launch an SSIS package after a SQL event takes place? I need to run a package after a customer order is placed. Can a trigger in SQL launch the package?

You can use xp_cmdshell to call DTEXEC. You could also set up a job for the package and call sp_start_job.

See this link for some more detail and some other options: http://blogs.msdn.com/michen/archive/2007/03/22/running-ssis-package-programmatically.aspx

Launch of SQL 2005.. any live conference broadcast ?

With the launch tomorrow or today in some countries, is there any live event
that may be broadcasted to people that cannot attend ?http://www.microsoft.com/emea/steveballmerlive/
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Hassan" <hassanboy@.hotmail.com> wrote in message
news:%23It2vT24FHA.1420@.TK2MSFTNGP09.phx.gbl...
> With the launch tomorrow or today in some countries, is there any live
> event that may be broadcasted to people that cannot attend ?
>