Home Library Learn Downloads Support Community
Sign in | United States - English | |
This topic has not yet been rated - Rate this topic

DTSEventFilterKind Enumeration

Describes the kind of event filter that is set on logging.

Namespace:  Microsoft.SqlServer.Dts.Runtime
Assembly:  Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)
C#
C++
F#
JScript
VB
Copy 
public enum DTSEventFilterKind
Member name Description
Inclusion Indicates that the events added to the event filter are included in the event log.
Exclusion Indicates that the events added to the event filter are excluded from the event log.
Exception Condition
DTS_E_INVALIDARG()

One or more arguments are invalid. Occurs when the filter is set to a filter value that is not a member of the DTSEventFilterKind enumeration.

Events are included or excluded from the event log by setting the DTSEventFilterKind of the container. The DTSEventFilterKind enumeration contains two values: Exclusion and Inclusion, which indicate whether the events are included or excluded from the event log.

The following code example enables logging on a package, adds a log provider, then displays the default value of the EventFilterKind. Using the DTSEventFilterKind enumeration, the default value is changed.

C#
VB
Copy 
using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.SqlServer.Dts.Runtime;

namespace Microsoft.SqlServer.SSIS.Sample
{
    class Program
    {
        static void Main(string[] args)
        {
            Package pkg = new Package();
            pkg.LoggingMode = DTSLoggingMode.Enabled;
            LogProvider log1 = pkg.LogProviders.Add("DTS.LogProviderTextFile.1");
            pkg.LoggingOptions.SelectedLogProviders.Add(log1);
            LoggingOptions lOpts = pkg.LoggingOptions;
            Console.WriteLine("EventFilterKind: {0}", pkg.LoggingOptions.EventFilterKind.ToString());

            pkg.LoggingOptions.EventFilterKind = DTSEventFilterKind.Inclusion;
            Console.WriteLine("EventFilterKind: {0}", pkg.LoggingOptions.EventFilterKind.ToString());
        }
    }
}

Sample Output:

EventFilterKind: Exclusion

EventFilterKind: Inclusion

Did you find this helpful?
(1500 characters remaining)