Post reply

Testing DTS Visual Basic ActiveX Scripts

  • January 5, 2004 at 2:49 pm

    #59109

    Is there a way to step thru VB ActiveX Scripts that are currently being used in DTS Packages? Is there a way to step thru each line of code and look at the values stored in variables? (Like we can do with regular VB.)

  • January 5, 2004 at 4:51 pm

    #488739

    If you don't have Visual Studio .Net download and install the Script Debugger

    http://msdn.microsoft.com/library/default.asp?url=/downloads/list/webdev.asp

    Then turn-on Just-in-Time debugging by right clicking on the 'Data Transformation Services' and selecting Properties.

    Put a 'Stop' statement in your script where you want to start the debugging.

    With Visual Studio .Net you'll get a dialog asking which debugger you want to use, just choose the script editor. From there on it's the same as debugging in any other .Net app with watchs, locals, etc...

    With the Script Debugger it's a bit more primitive. You can step through the code but to see what the variable values are you'll need to print them in the command window.

    Two points to note,

    1) Both debugging methods are read-only

    2) Make sure you close the window when you've finished debugging otherwise you'll end up with multiple windows and it'll get a little confusing.

     

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

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

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