Post reply

How to stop a DTS package running a VBScript?

  • September 16, 2003 at 2:32 pm

    #106499

    I have a DTS package that executes many VBScripts in ActiveX Script tasks. If I hit the cancel button while it is executing it won't stop while executing at least one of the VBScripts.

    If I right click the package in a white area and select Package Properties, logging tab, and check the box beside Fail package on first error and then run the package making sure that at least one task fails, it still does not stop while executing a VBScript.

    Since the VBScript in question executes a do loop that will only stop when a specific value is assigned to a global variable it never stops.

    The only way I have found so far to stop such a package is to use the task manager and force Enterprise Manager to close.

    Has anyone seen this and/or know of a way to make such a package stop automatically when it encounters an error?

    Robert W. Marda

    SQL Programmer

    bigdough.com

    The world’s leading capital markets contact database and software platform.

    Robert W. Marda
    Billing and OSS Specialist - SQL Programmer
    MCL Systems

  • September 16, 2003 at 5:15 pm

    #474532

    Unfortunately, the only way is to kill EM. One of the main drawbacks with DTS is that is doesn't really provide a good development environment. I mean you can't even find & replace in the script editor. It is getting better, it took a big jump from SQL7 to SQL2K, but it's still got a little way to go.

    Hope this helps

    Phill Carter

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

    Colt 45 - the original point and click interface

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

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

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