The Properties collection contains Property objects exposing the attributes of a DTS object property.
Object properties implement instance data for OLE objects. DTS is implemented as a dual-interface object library. Its objects are exposed as OLE Automated objects and as COM objects, allowing developers to use either an OLE Automation controller or a C/C++ compiler as an application development platform.
Automation controllers, such as Microsoft® Visual Basic®, typically enrich the development experience by providing syntax completion and other development aids. Because it exposes the attributes of object properties, the Property object is a central component of automated developer assistance.
When using the Item method, the Properties collection supports member identification using either name or ordinal reference syntax. For example:
Set oProperty = oCustomTask.Properties("Name")
Or:
Set oProperty = oCustomTask.Properties(1)
Note The Properties collection is implemented for OLE Automation controllers. The C/C++ SQL-DMO application has no direct access to the Property object.
| Item Method |
| Count Property |