DTSLogEntryFrequency Enumeration
Provides information to assist in log planning. You pick the hint that most closely corresponds to the frequency that you expect to generate a particular log entry in your task. This enumeration property then assists users of the package when they want to set up filtering of log entries. The user can view the property, and know in advance if there will be an overwhelming number of entries of a particular type, and plan accordingly.
Assembly: Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)
| Member name | Description | |
|---|---|---|
| Consistent | The entry is logged a consistent number of times, not proportional to the workload. For example, a log that is created at the beginning and in the end of a task. | |
| Occasional | The entry is logged sometimes, usually in exceptional cases. | |
| Proportional | The entry is logged a number of times proportional to the workload. |
The following code example iterates over the LogEntryInfos collection, and then prints the properties of each LogEntryInfo found, including FrequencyHint, which returns a value from this enumeration. The code example does show how to set the FrequencyHint because the property is read-only.
Sample Output:
Number of log entries: 1
CreationName:
Description: Logs package diagnostics information, e.g. maximum concurrent executables
FrequencyHint: Consistent
ID: {65F44252-EB0C-4CCB-ADE4-BA4AB86B4CF9}
Name: Diagnostic