LogEntryInfos.Add(String, String, DTSLogEntryFrequency) Methode
Definition
Wichtig
Einige Informationen beziehen sich auf Vorabversionen, die vor dem Release ggf. grundlegend überarbeitet werden. Microsoft übernimmt hinsichtlich der hier bereitgestellten Informationen keine Gewährleistungen, seien sie ausdrücklich oder konkludent.
Fügt der LogEntryInfo-Auflistung ein neues LogEntryInfos-Objekt hinzu.
public:
void Add(System::String ^ name, System::String ^ description, Microsoft::SqlServer::Dts::Runtime::DTSLogEntryFrequency frequencyHint);
public void Add (string name, string description, Microsoft.SqlServer.Dts.Runtime.DTSLogEntryFrequency frequencyHint);
member this.Add : string * string * Microsoft.SqlServer.Dts.Runtime.DTSLogEntryFrequency -> unit
Public Sub Add (name As String, description As String, frequencyHint As DTSLogEntryFrequency)
Parameter
- name
- String
Der Name des Protokolleintrags, der der Auflistung hinzugefügt werden soll.
- description
- String
Eine Beschreibung für den Protokolleintrag.
- frequencyHint
- DTSLogEntryFrequency
Einer der gültigen Werte aus dem DTSLogEntryFrequency-Enumerator.
Beispiele
Im folgenden Codebeispiel wird der Auflistung ein Protokolleintrag hinzugefügt.
using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.SqlServer.Dts.Runtime;
namespace LogEntryInfosTest
{
class Program
{
static void Main(string[] args)
{
// The package is one of the SSIS Samples.
string mySample = @"C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services\Package Samples\CalculatedColumns Sample\CalculatedColumns\CalculatedColumns.dtsx";
// Create the Application, and load the sample.
Application app = new Application();
Package pkg= app.LoadPackage(mySample, null);
// Get the LogEntryInfos from the package.
LogEntryInfos logInfos = pkg.LogEntryInfos;
//Note how many log entries exist before adding one.
String countLEI = logInfos.Count.ToString();
Console.WriteLine("Entries at beginning: {0}", countLEI);
String newName = "My new log entry info";
String newDesc = "My new Description";
DTSLogEntryFrequency newFreq = DTSLogEntryFrequency.Consistent;
logInfos.Add(newName, newDesc, newFreq);
//Note how many log entries exist after adding one.
countLEI = logInfos.Count.ToString();
Console.WriteLine("Entries after adding one: {0}", countLEI);
//Now remove the entry just added.
logInfos.Remove("My new log entry info");
countLEI = logInfos.Count.ToString();
Console.WriteLine("Entries after Remove: {0}", countLEI);
}
}
}
Imports System
Imports System.Collections.Generic
Imports System.Text
Imports Microsoft.SqlServer.Dts.Runtime
Namespace LogEnTryInfosTest
Class Program
Shared Sub Main(ByVal args() As String)
' The package is one of the SSIS Samples.
Dim mySample As String = "C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services\Package Samples\CalculatedColumns Sample\CalculatedColumns\CalculatedColumns.dtsx"
' Create the Application, and load the sample.
Dim app As Application = New Application()
Dim pkg As Package = app.LoadPackage(mySample,Nothing)
' Get the LogEntryInfos from the package.
Dim logInfos As LogEnTryInfos = pkg.LogEnTryInfos
'Note how many log entries exist before adding one.
Dim countLEI As String = logInfos.Count.ToString()
Console.WriteLine("Entries at beginning: {0}", countLEI)
Dim NewName As String = "My new log entry info"
Dim NewDesc As String = "My new Description"
Dim NewFreq As DTSLogEnTryFrequency = DTSLogEnTryFrequency.Consistent
logInfos.Add(NewName, NewDesc, NewFreq)
'Note how many log entries exist after adding one.
countLEI = logInfos.Count.ToString()
Console.WriteLine("Entries after adding one: {0}", countLEI)
'Now remove the entry just added.
logInfos.Remove("My new log entry info")
countLEI = logInfos.Count.ToString()
Console.WriteLine("Entries after Remove: {0}", countLEI)
End Sub
End Class
End Namespace
Beispielausgabe:
Einträge am Anfang: 1
Einträge nach dem Hinzufügen eines: 2
Einträge nach dem Entfernen: 1