Post reply

Terminate DTS package from VB.EXE

  • August 5, 2004 at 11:13 am

    #60203

    Hi All,

    I'm trying to kill a DTS package from a VB executable I've created.  Here's the process.

    Purpose:

    Check new loads against existing thresholds.  If new loads are less than thresholds, kill the dts package.

    My intended process:

    1.Run the DTS package and step "n" run this VB utility that does the check

    1a. The utility contains db calls/e-mail calls/and other specific VB only functionality.

    2.If the data loads are less than the thresholds kill the package from within this VB utility using the DTS.package object

    Essentially the package is kill itself

     

    Thanks

  • August 5, 2004 at 12:12 pm

    #517890

    If you are using VB6, I recommend you just use the following syntax:

    Set DTSObj = Nothing

    Have you tried this option?

  • August 7, 2004 at 1:21 am

    #518097

    Look into using an ActiveScript step/task to do some of the evaluation that your VB program is instead doing. Then you want to set the step's evaluation from "Success" to "Failure" as required, and change the step following this from "Completion" to "Success", otherwise the rest of the chain will execute.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply