Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
DBunn
Starting Member
14 Posts |
 Posted - 2002-09-03 : 12:46:25
|
| Is it possible to create a reference to a step within the ActiveX code of the same step?Ultimately, I would like to create a generic ActiveX script that will find the next step in the process by looping through the packages step objects until it finds one with a constraint precedence of the current step. To do this I've had to hard code the name of the present step in the code and that removes the generic plug'n'play aspect I'd like to have. Is there any method for a step's code to supply the name of its own step object? |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-09-03 : 13:08:00
|
| When you say "current step" are you referring to the step that may be executing at that moment? An ActiveX script that enumerates through the packages step objects can check the ExecutionStatus property for each step to determine which one(s) is/are running, but I don't know if that helps or not.I don't remember if the Me keyword is available in VBScript, but if it is you should be able to use it to refer to a step object. There is also the Parent property, it might help you to identify the next step of the process. |
 |
|
|
|
|
|
Which step am I ??