DtsContainer.LogEntryInfos 属性

定义

命名空间:

Microsoft.SqlServer.Dts.Runtime

程序集:

Microsoft.SqlServer.ManagedDTS.dll

返回一个 LogEntryInfos 对象。 此属性为只读。

public:
 property Microsoft::SqlServer::Dts::Runtime::LogEntryInfos ^ LogEntryInfos { Microsoft::SqlServer::Dts::Runtime::LogEntryInfos ^ get(); };

public Microsoft.SqlServer.Dts.Runtime.LogEntryInfos LogEntryInfos { get; }

member this.LogEntryInfos : Microsoft.SqlServer.Dts.Runtime.LogEntryInfos

Public ReadOnly Property LogEntryInfos As LogEntryInfos

属性值

LogEntryInfos

LogEntryInfos 对象。

示例

下面的代码示例演示 Package 了如何使用 Package.LogEntryInfos 集合。 类Package继承集合的LogEntryInfos用法。DtsContainer

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  

示例输出：

开头的条目：1

添加一个后条目： 2

删除后的条目：1

注解

有关详细信息，请参阅 Integration Services (SSIS) 日志记录。