DTS Package Execution

• bikout

  Valued Member

  Points: 73

  More actions

  January 8, 2002 at 8:23 am

  #158061

  How can I run a DTS package, that contains a Java application, as a result of a database insert event that fires an SQL-trigger?

  It seems impossible, even if I try to run the package as a sceduled Job in SQLServer 2000.

  However, in the DTS Package Designer environment the Java-application Package is executed successfully...

  Thanks in advance.

• K. Brian Kelley

  SSC Guru

  Points: 114552

  More actions

  January 8, 2002 at 8:33 am

  #421891

  Please do not crosspost. Most of us check all the forums. I have replied in the DTS forum.

  K. Brian Kelley

  bkelley@sqlservercentral.com

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

  Edited by - bkelley on 01/08/2002 08:34:47 AM

  K. Brian Kelley
  @kbriankelley