Article
09/27/2010

Énumération DTSEventFilterKind

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

Espace de noms : Microsoft.SqlServer.Dts.Runtime
Assembly : Microsoft.SqlServer.ManagedDTS (dans Microsoft.SqlServer.ManagedDTS.dll)

Syntaxe

'Déclaration
Public Enumeration DTSEventFilterKind
'Utilisation
Dim instance As DTSEventFilterKind

public enum DTSEventFilterKind

public enum class DTSEventFilterKind

type DTSEventFilterKind

public enum DTSEventFilterKind

Membres

	Nom de membre	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.

Exceptions

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.

Notes

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.

Exemples

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.

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.2");
            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());
        }
    }
}

Imports System
Imports System.Collections.Generic
Imports System.Text
Imports Microsoft.SqlServer.Dts.Runtime
 
Namespace Microsoft.SqlServer.SSIS.Sample
    Class Program
        Shared  Sub Main(ByVal args() As String)
            Dim pkg As Package =  New Package() 
            pkg.LoggingMode = DTSLoggingMode.Enabled
            Dim log1 As LogProvider =  pkg.LogProviders.Add("DTS.LogProviderTextFile.2") 
            pkg.LoggingOptions.SelectedLogProviders.Add(log1)
            Dim lOpts As LoggingOptions =  pkg.LoggingOptions 
            Console.WriteLine("EventFilterKind: {0}", pkg.LoggingOptions.EventFilterKind.ToString())
 
            pkg.LoggingOptions.EventFilterKind = DTSEventFilterKind.Inclusion
            Console.WriteLine("EventFilterKind: {0}", pkg.LoggingOptions.EventFilterKind.ToString())
        End Sub
    End Class
End Namespace

Sample Output:

EventFilterKind: Exclusion

EventFilterKind: Inclusion

Voir aussi

Référence

Espace de noms Microsoft.SqlServer.Dts.Runtime

Partager via