Metoda LoggingOptions.GetColumnFilter
Zwraca filtr kolumn dla określonego zdarzenie.
Przestrzeń nazw: Microsoft.SqlServer.Dts.Runtime
Zestaw: Microsoft.SqlServer.ManagedDTS (w Microsoft.SqlServer.ManagedDTS.dll)
Składnia
'Deklaracja
Public Sub GetColumnFilter ( _
eventName As String, _
ByRef columnFilter As DTSEventColumnFilter _
)
'Użycie
Dim instance As LoggingOptions
Dim eventName As String
Dim columnFilter As DTSEventColumnFilter
instance.GetColumnFilter(eventName, columnFilter)
public void GetColumnFilter(
string eventName,
ref DTSEventColumnFilter columnFilter
)
public:
void GetColumnFilter(
String^ eventName,
DTSEventColumnFilter% columnFilter
)
member GetColumnFilter :
eventName:string *
columnFilter:DTSEventColumnFilter byref -> unit
public function GetColumnFilter(
eventName : String,
columnFilter : DTSEventColumnFilter
)
Parametry
- eventName
Typ: System.String
Nazwa kolumny, których chcesz kontrolować zdarzenie.
- columnFilter
Typ: Microsoft.SqlServer.Dts.Runtime.DTSEventColumnFilter%
A DTSEventColumnFilter z wartościami zestaw do true lub false, w zależności od tego, jeżeli kolumna jest włączone (true) lub wykluczone (false).
Przykłady
Poniższy kod ilustruje tworzenie Package i wybierze dostawca dziennika o typie.Przykładowy kod ustawia następnie pole DTSEventColumnFilter do true uwzględnienie tego pole w dzienniku, lub false wykluczenie pole z dziennika.SetColumnFilter Określa, że pola z wartością true są rejestrowane, gdy ponosi pakiet OnErrorzdarzenie. Nowy DTSEventColumnFilter jest utworzony i wypełnione wartościami z istniejących przy użyciu filtru 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.2");
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.2")
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
Przykładowe dane wyjściowe:
Computer: True
Operator: True
SourceName: True
SourceID: False
ExecutionID: False
MessageText: False
DataBytes: False