guys

any idea how (if at all possible) to rename the task names in dts? i am talking about ones like "DTS_EXECUTESQL_TASK_1

thanks
alex;

Yup - either disconnected edit or using dynamic properties and/or within
ActiveX scripts.

Will mess up dependencies - be careful!

"alex guindon" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Be very very careful. It is always best to do this right up front before
defing any dependencies.

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Joe" <hortoristic (AT) yahoo (DOT) com> wrote

"Joe" <hortoristic (AT) yahoo (DOT) com> wrote

In particular, be sure to update the reference to the task under its
corresponding step.

JP

In message <1f323b67.0402060947.14b62240 (AT) posting (DOT) google.com>, JP
<SocSecTrainWreck (AT) earthlink (DOT) net> writes
To elaborate, the step has TaskName property that relates the step to
the task. If renaming the step too, which makes sense, then for any
workflow, the succeeding step owns the workflow that has StepName
property relating the constraint to the preceding step. BTW it is
simplest is you do this before you add any workflow.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org