Code DTS Event handlers in an ActiveX Script in the DTS Package

When executing a DTS Package in VB6 using the DTS Object etc ... You
can install
the DTS Event handlers and add code to them

see article
http://support.microsoft.com/default...;EN-US;Q221193

Can the same be done in a ActiveX Script?
So your code fires when a specific DTS event fires

This ActiveX Script has to be in the DTS package
and the events in it must only fire when the mapped DTS events fire.

RAG,

That would be too cool. To be able to do this the script engine itself has
to aware of events. To specify the event script the engine has to know the
script location and subroutine name, which can be defaulted to say 'Main'. I
do not believe any of that is available in DTS. You can try to simulate all
this by something like writing a custom task in VB which would take task
names (not only script tasks) as parameters and execute them on events. The
only limitation of this is custom task has to be executed on main package
thread and by that it is single threaded.

Ilya

"RAG" <ragubir.dhiman (AT) pslconnect (DOT) com> wrote