Call ssis package from service broker queue

• mupparaju78

  SSChasing Mays

  Points: 646

  More actions

  September 7, 2011 at 1:47 am

  #104090

  Hi,

  i want execute ssis package from service broker queue.how can i call ssis package.

  plz let me know the best way.

• Orlando Colamatteo

  SSC Guru

  Points: 182279

  More actions

  September 24, 2011 at 7:37 am

  #1386100

  "Best" will be relative. I suggest you do some reading into what Service Broker offers in terms of activation:

  http://msdn.microsoft.com/en-us/library/ms171617(v=SQL.90).aspx

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato