Passing parameters from a Trigger to DTS

• dchitm

  SSC Veteran

  Points: 234

  More actions

  December 12, 2003 at 12:15 pm

  #107029

  How do I passin a paramenter from a trigger to a DTS?

• December 15, 2003 at 8:00 am

  This was removed by the editor as SPAM

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736068

  More actions

  December 15, 2003 at 10:45 am

  #486214

  how are you running the DTS job? xp_cmdshell/dtsrun or sp_Start_job?

  In general I'd say that this is a bad idea.

  Steve Jones

  sjones@sqlservercentral.com

  http://www.sqlservercentral.com/columnists/sjones

  The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

  http://www.dkranch.net