June 10, 2003 at 9:46 am
I am trying to utilize the variable DTSStep_DTSActiveScriptTask_X (where X refers to the task number) to control the flow of my program. My question is if I have been creating the DTS package piece by piece and not necessarily in order from first to last how do I know which Active X Script Task a particular DTSStep_DTSActiveScriptTask_X refers to? Is it determined by the way I have created them? If so, I do not remember which order I created them in. Is there a way to point to an Active X script task by description? Right now I am trying to user code like the following:
SET stpContinuePkg = pkg.Steps("DTSStep_DTSActiveScriptTask_3") but I'm not sure which ActiveScriptTask the above refers to. Any help would be appreciated.
Regards,
Bessebo
SET stpContinuePkg = pkg.Steps("DTSStep_DTSActiveScriptTask_3")
June 11, 2003 at 4:34 am
If you gave your items an individual description then you can open the DTS package in EM and on the toolbar pick Package->Disconnected Edit... . Thsi will pull up the "Edit All Package Properties" dialog with a treeview on the left and details on the right section. In the treeview expand "Steps" and you will see the step names of you package. Click the one labeled "DTSStep_DTSActiveScriptTask_3" and in the details on the right you will see Description and in taht field you will see the Description you gave the step. You can make changes to this so you get better output but there are some headaches involved with some items.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply