LoggingOptions.GetColumnFilter(String, DTSEventColumnFilter) Método

  • Referência

Definição

Namespace:
Microsoft.SqlServer.Dts.Runtime
Assembly:
Microsoft.SqlServer.ManagedDTS.dll

Retorna a o filtro de coluna para o evento especificado.

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)

Parâmetros

eventName
String

O nome do evento cujas colunas você deseja controlar.

columnFilter
DTSEventColumnFilter

Um DTSEventColumnFilter com valores definidos como true ou false, dependendo se a coluna for incluída (true) ou excluída (false).

Exemplos

O exemplo de código a seguir cria um Package e seleciona um provedor de log para ele. O exemplo de código, em seguida, define os campos do DTSEventColumnFilter campo para true incluir esse campo no log ou false para excluir o campo do log. Em SetColumnFilter seguida, define que os campos com um valor de true são registrados quando o pacote incorre em um OnError evento. Um novo DTSEventColumnFilter é criado e preenchido com os valores do filtro existente 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

Saída de exemplo:

Computador: True

Operador: True

SourceName: True

SourceID: False

ExecutionID: False

MessageText: False

DataBytes: False

Aplica-se a