In message <1006aanc2p1ar8c (AT) corp (DOT) supernews.com>, Joe
<nwservices (AT) olynet (DOT) com> writes
Quote:
How can I referance a task by name instead of by its Task #?
This works:
Set oPkg = DTSGlobalVariables.Parent
Set oStep = oPkg.Steps("DTSStep_DTSActiveScriptTask_3")
Need it to be like this:
Set oPkg = DTSGlobalVariables.Parent
Set oStep = oPkg.Steps("MyTaskName") |
You are referencing the task by name.
DTSStep_DTSActiveScriptTask_3 is probably the step name, and MyTaskName
is the description. Unfortunately the task/step description is what you
see most of and is easily changed.
You can change your step name through Disconnected Edit, but be careful
if you have workflow. If changing task names you must also change the
TaskName property of the Step to match.
--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com
PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org