TaskInfos Collection

DTS Programming

DTS Programming

TaskInfos Collection

The TaskInfos collection contains TaskInfo objects that provide information about each DTS task available on the system. These include the tasks supplied by Microsoft® SQL Server™ 2000 and custom tasks implemented by users or other vendors.

Properties
Count Property UseCache Property
Parent Property  
Methods
Item Method Refresh Method

Remarks

Obtain a reference to the TaskInfos collection from the Application object. For more information about the tasks supplied with SQL Server 2000, see Task Objects.

You can iterate through the objects of the TaskInfos collection using the Item method and Count property. However, it is faster to use For Each ... Next in Microsoft Visual Basic®.

DTS maintains a cache, in the operating system registry, that holds the task information. If the UseCache property is TRUE, the cache, rather than all registered classes, is scanned when iterating through the XXXXs collection. Use the Refresh method to update the cache from the registered classes section of the system registry.

See Also

Application Object

Item Method

Refresh Method

Retrieving DTS System, Package and Log Data

TaskInfo Object

UseCache Property