LogEntryInfos.Remove Method

Removes a LogEntryInfo object from the LogEntryInfos collection.

Namespace: Microsoft.SqlServer.Dts.Runtime
Assembly : Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)

Syntax

'Declaration
Public Sub Remove ( _
    index As Object _
)

public void Remove (
    Object index
)

public:
void Remove (
    Object^ index
)

public void Remove (
    Object index
)

public function Remove (
    index : Object
)

Parameter

• index
  The name, ID, or index of the LogEntryInfo object to locate in the collection.

Beispiel

The following code example removes an item from the collection using the name as the index.

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\90\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\90\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

Sample Output:

Entries at beginning: 1

Entries after adding one: 2

Entries after Remove: 1

Threadsicherheit

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Plattformen

Entwicklungsplattformen

Eine Liste der unterstützten Plattformen finden Sie unterHardware- und Softwareanforderungen für die Installation von SQL Server 2005.

Zielplattforme

Eine Liste der unterstützten Plattformen finden Sie unterHardware- und Softwareanforderungen für die Installation von SQL Server 2005.

Siehe auch

Verweis

LogEntryInfos Class
LogEntryInfos Members
Microsoft.SqlServer.Dts.Runtime Namespace