DTS Programming
EOF Property
The EOF property specifies whether all the elements have been fetched while iterating through the associated collection.
Applies To
| PackageInfos Collection | StepLineages Collection |
| PackageLineages Collection | StepLogRecords Collection |
| PackageLogRecords Collection | TaskLogRecords Collection |
Syntax
collection.EOF
| Part | Description |
|---|---|
| collection | Expression that evaluates to a collection in the Applies To list |
Data Type
Boolean
Modifiable
Read-only
Prototype (C/C++)
HRESULT GetEOF(VARIANT_BOOL *pRetVal);
Remarks
Iterate through a collection by checking the EOF property after calling the Next method. If EOF is TRUE, Next will have returned Nothing and all of the elements will have been fetched. The following Microsoft® Visual Basic® code shows this process:
Set object = collection.Next
Do Until collection.EOF
. . .
Set object = collection.Next
Loop
The collections in the Applies To list also can be processed using For Each ... Next in Visual Basic:
For Each object In collection
. . .
Next object