local package trigger

• powerdude

  Old Hand

  Points: 394

  More actions

  October 24, 2003 at 6:23 am

  #160893

  I created a local package thru DTS that has a connection to a particular file location of which it is used to update the database. I would like to know if it is possible to create a trigger to change the connection file location depending on certain circumstances. The package is currently stored in the msdb database. I was hoping to create such a trigger to update the file/table location field in the msdb database. Unfortunately, I cannot find where this info is stored. Any help will be appreciated.

  Patrick Quinn

  TRMS Database Administrator

• philcart

  SSC-Forever

  Points: 47794

  More actions

  October 26, 2003 at 3:11 pm

  #479601

  The DTS package is stored as a binary object in msdb, so you won't be able to change it using a trigger.

  Your best approach would be to dynamically assign things like the file/table location using global variables.

  Hope this helps

  Phill Carter

  --------------------

  Colt 45 - the original point and click interface

  --------------------
  Colt 45 - the original point and click interface