In the ActiveX script I have to reference different tasks but the names are
very convoluted and not intuitive, for example DTSTask_DTSDataPumpTask_3.

How can I name these tasks appropriately ?

If you are going to start renaming the tasks and steps etc then do this
right at the start of your package as they have interdependencies with
constraints etc. I usually store a ref to the object like this though

dim pkg, tsk

SET pkg = DTSGlobalVariables.Parent
SET tsk = pkg.Tasks("DTSTask_DTSDataPumpTask_3").CustomTask


.....

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"GMG" <nospam (AT) nospam (DOT) com> wrote

How do you actually rename tasks through the interface (the only option you
are given is a description) ?
The only way I can see is to export it to VB script, rename the objects and
somehow reimport it as a DTS package, is this how to do it or is there a
better way ?


"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

You could do that or you can use Disconnected Edit.

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"GMG" <nospam (AT) nospam (DOT) com> wrote