all groups > sql server dts > january 2006 >
You're in the

sql server dts

group:

Debugging VB Script within DTS Package


Debugging VB Script within DTS Package Larry Bird
1/21/2006 9:16:02 AM
sql server dts:
I’m experiencing a problem with a VB Script inside a DTS Package. When I
run the task via the Package designer it runs fine. However, when I run the
entire package the result is different.

I need to be able to debug the VB script within the package. The script
uses DTS global variables so I’m unable to run it as a standard script. The
server is a Windows 2003 Standard server running SQL server 2000 standard
edition.

Does anyone have any ideas?

Thanks
Re: Debugging VB Script within DTS Package vadim.svinkin NO[at]SPAM gmail.com
1/23/2006 8:37:02 AM
I'm using combination of MsgBox and logging values to a couple of
tables through ADODB.Connection.

Vadim.
Re: Debugging VB Script within DTS Package Darren Green
1/23/2006 8:10:54 PM
[quoted text, click to view]

You can use the MS Script Debugger, free download I believe.

Using a STOP statement should allow you to attach to the process. This
is not always 100% reliable, but a MsgBox will pause execution and you
can attach then.

Check the properties of the DTS node in EM, there is a JIT debug option
I think, probably need to turn it on. (It has been a while...)


--
Darren
http://www.sqldts.com
AddThis Social Bookmark Button