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.