Post reply

Debugging DTS / ActiveX VBScript....

  • November 7, 2005 at 10:36 am

    #67593

     Hi,

    I'm a newbie at DTS development. i've been tasked with writing an import package. The main problem I'm having (well, one of them) is debugging the proc. E.g. finding the values of variables etc.

    Could someone point me at docs concerning this or give some general advice?

     

    I'm not sure what specs you'd need to know so let me know what info I can supply.

     

    Thanks,

    Dan

  • November 8, 2005 at 3:24 am

    #602744

    Hi Dan,

    Debugging VB script in DTS is a next to impossible and the documentation isn't great. That said, here is a link to the DTS programming reference which should help.

    http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dtsprog/dtspapps_0jsd.asp

    I tend to write my vbscript in another editor and then paste the code into the vbscript task.

    Good luck.

    Daniel

  • November 8, 2005 at 7:15 am

    #602782

    Here's another good link on dts:

    http://www.sqldts.com/

  • November 8, 2005 at 10:55 am

    #602846

    One thing you can try is sticking message boxes with the variable value in areas where you have questions. Comment the code underneath it out so that it doesn't run. Seems to work well for me.

  • November 8, 2005 at 11:58 am

    #602862

    Also,

    If you have Visual Studio installed you can put a STOP command in any ActiveX Script and it will prompt you for debugging (it is well worth trying to get Visual Studio installed for this :blush.

Viewing 5 posts - 1 through 4 (of 4 total)

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