Hi

I have recorded a DTS package in Enterprise manager. I paste the code into
VBA. However I do not understand how the program works. I am trying to
cutomise it. I think I can get around VB but how does the activeX scripts

Hello Gallardo,

You have reverse engineered a package into VB and now want to call that code/package.
Are you trying to put the code into A.N.Other package? That won't work.
AX Scripts within the package will fire when their time comes through precedence
constraints. Tasks in DTS have an order when constrained through workflow
otherwise they are free to go when they get scheduled in.

I hardly if indeed ever use the reverse engineering to execute packages.
All this does is builds a package and then executes the package when I call
the module. DTS is relatively flexible and I can usually modify it without
resorting to this method.

What mods do you want to do.

--

Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com

[quoted text, click to view]