From Doug Waldron.
For instance, using Microsoft Word:
Save the DTS package to the file system.
Tools->Macro->Visual Basic Editor
Pops a Visual Basic 6 Window.
View->code
Cut and past your code into the new window
Tools->References
check Microsoft DTSPackage Object Libray
check Microsoft DTS Custome Tasks Object Library
check Microsoft DTSDataPump Scripting Object Library
F8 to step through
F9 to set break point
F5 to run