Debugging DTS / ActiveX VBScript....

Question

Debugging DTS / ActiveX VBScript....

Dan Potter

SSC Enthusiast

Points: 190
More actions
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

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

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

Daniel Forrester-253836 Say Hey Kid Points: 666 More actions · Answer 1

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

MarkA-218060 SSC Veteran Points: 241 More actions · Answer 2

Here's another good link on dts:

http://www.sqldts.com/

Tim Cullen Ten Centuries Points: 1394 More actions · Answer 3

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.

DSP-120308 Hall of Fame Points: 3959 More actions · Answer 4

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.