TransformationInfos Collection
The TransformationInfos collection contains TransformationInfo objects that provide information about each DTS transformation available on the system. These include the transformations supplied by Microsoft® SQL Server™ 2000 and custom transformations implemented by users or other vendors.
Properties
| Count Property | UseCache Property |
| Parent Property |
Methods
| Item Method | Refresh Method |
Remarks
Obtain a reference to the TransformationInfos collection from the Application object. For more information about the transformations supplied with SQL Server 2000, see Transformation Objects.
You can iterate through the objects of the TransformationInfos 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 transformation information. If the UseCache property is TRUE the cache is scanned, rather than all registered classes, when iterating through the TransformationInfos collection. Use the Refresh method to update the cache from the registered classes section of the system registry.