LoggingOptions.GetColumnFilter(String, DTSEventColumnFilter) Metodo

Definizione

Restituisce il filtro di colonna per l'evento specificato.

public:
 void GetColumnFilter(System::String ^ eventName, Microsoft::SqlServer::Dts::Runtime::DTSEventColumnFilter % columnFilter);
public void GetColumnFilter (string eventName, ref Microsoft.SqlServer.Dts.Runtime.DTSEventColumnFilter columnFilter);
member this.GetColumnFilter : string * DTSEventColumnFilter -> unit
Public Sub GetColumnFilter (eventName As String, ByRef columnFilter As DTSEventColumnFilter)

Parametri

eventName
String

Nome dell'evento di cui si desidera controllare le colonne.

columnFilter
DTSEventColumnFilter

Oggetto DTSEventColumnFilter con valori impostati su true o false, a seconda che la colonna sia inclusa (true) o esclusa (false).

Esempio

Nell'esempio di codice seguente viene creato un oggetto Package e viene selezionato un provider di log. Nell'esempio di codice vengono quindi impostati i campi di DTSEventColumnFilter su per true includere tale campo nel log o false per escludere il campo dal log. SetColumnFilterDefinisce quindi che i campi con un valore true vengono registrati quando il pacchetto comporta un OnError evento. Viene creato un nuovo oggetto DTSEventColumnFilter e vengono inseriti i valori del filtro esistente usando GetColumnFilter .

using System;  
using System.Collections.Generic;  
using System.Text;  
using Microsoft.SqlServer.Dts.Runtime;  

namespace HttpClientConn  
{  
    class Program  
    {  
        static void Main(string[] args)  
        {  
            Package pkg = new Package();  
            LogProvider log1 = pkg.LogProviders.Add("DTS.LogProviderTextFile.1");  
            pkg.LoggingOptions.SelectedLogProviders.Add(log1);  
            LoggingOptions lOpts = pkg.LoggingOptions;  

            DTSEventColumnFilter ecf = new DTSEventColumnFilter();  
            // Set the detailed information to log when the event occurs.  
            // This specifies to log the Computer, Operator, and SourceName only.  
            ecf.Computer = true;  
            ecf.Operator = true;  
            ecf.SourceName = true;  
            ecf.SourceID = false;  
            ecf.ExecutionID = false;  
            ecf.MessageText = false;  
            ecf.DataBytes = false;  
            // The event is the first parameter, and the columns to log is the enumeration.   
            lOpts.SetColumnFilter("OnError", ecf);  

            // Now that the column filters are set, retrieve them using   
            // GetColumnFilter.  
            DTSEventColumnFilter newECF = new DTSEventColumnFilter();  
            lOpts.GetColumnFilter("OnError", ref newECF);  

            // Show that the new DTSEventColumnFilter has been set properly.  
            Console.WriteLine("Computer: {0}", newECF.Computer);  
            Console.WriteLine("Operator: {0}", newECF.Operator);  
            Console.WriteLine("SourceName: {0}", newECF.SourceName);  
            Console.WriteLine("SourceID: {0}", newECF.SourceID);  
            Console.WriteLine("ExecutionID: {0}", newECF.ExecutionID);  
            Console.WriteLine("MessageText: {0}", newECF.MessageText);  
            Console.WriteLine("DataBytes: {0}", newECF.DataBytes);  
        }  
    }  
}  
Imports System  
Imports System.Collections.Generic  
Imports System.Text  
Imports Microsoft.SqlServer.Dts.Runtime  

Namespace HttpClientConn  
    Class Program  
        Shared  Sub Main(ByVal args() As String)  
            Dim pkg As Package =  New Package()   
            Dim log1 As LogProvider =  pkg.LogProviders.Add("DTS.LogProviderTextFile.1")   
            pkg.LoggingOptions.SelectedLogProviders.Add(log1)  
            Dim lOpts As LoggingOptions =  pkg.LoggingOptions   

            Dim ecf As DTSEventColumnFilter =  New DTSEventColumnFilter()   
            ' Set the detailed information to log when the event occurs.  
            ' This specifies to log the Computer, Operator, and SourceName only.  
            ecf.Computer = True  
            ecf.Operator = True  
            ecf.SourceName = True  
            ecf.SourceID = False  
            ecf.ExecutionID = False  
            ecf.MessageText = False  
            ecf.DataBytes = False  
            ' The event is the first parameter, and the columns to log is the enumeration.   
            lOpts.SetColumnFilter("OnError", ecf)  

            ' Now that the column filters are set, retrieve them using   
            ' GetColumnFilter.  
            Dim NewECF As DTSEventColumnFilter =  New DTSEventColumnFilter()   
            lOpts.GetColumnFilter("OnError",ref NewECF)  

            ' Show that the new DTSEventColumnFilter has been set properly.  
            Console.WriteLine("Computer: {0}", NewECF.Computer)  
            Console.WriteLine("Operator: {0}", NewECF.Operator)  
            Console.WriteLine("SourceName: {0}", NewECF.SourceName)  
            Console.WriteLine("SourceID: {0}", NewECF.SourceID)  
            Console.WriteLine("ExecutionID: {0}", NewECF.ExecutionID)  
            Console.WriteLine("MessageText: {0}", NewECF.MessageText)  
            Console.WriteLine("DataBytes: {0}", NewECF.DataBytes)  
        End Sub  
    End Class  
End Namespace  

Esempio di output:

Computer: true

Operatore: true

SourceName: true

SourceID: false

ExecutionID: false

MessageText: false

DataBytes: false

Si applica a