We use a few custom tasks in our system in several DTS packages.
How can I query tables in MSDB to find all packages using a DTS task.

Also, how can I find a particular task property in various DTS packages
from the MSDB tables.

Thanks
Karen

Hello karenmiddleol@yahoo.com,

The rows in msdb.dbo.sysdtspackages store the package in binary as the package
itself. It does not store the comonent parts thereof.

To be able to say "Where is this task used?" you will need to open every
package and examine the Tasks collection. This would preferably (time) be
done through a programming construct.

Allan



[quoted text, click to view]

Hi Allan

Then probably it is the major limitation of DTS I see apart from this
DTS is quite good against other ETL tools.

Most ETL tools support features for impact analysis where a task is
used, where a connection is used or where a transform is used or where
a particular table or view is used.

Thanks
Karen