Item プロパティ

LogProvider オブジェクトをコレクションから返します。

名前空間:  Microsoft.SqlServer.Dts.Runtime
アセンブリ:  Microsoft.SqlServer.ManagedDTS (Microsoft.SqlServer.ManagedDTS.dll)

構文

'宣言
Public ReadOnly Default Property Item ( _
    index As Object _
) As LogProvider
    Get
'使用
Dim instance As SelectedLogProviders
Dim index As Object
Dim value As LogProvider

value = instance(index)
public LogProvider this[
    Object index
] { get; }
public:
property LogProvider^ default[Object^ index] {
    LogProvider^ get (Object^ index);
}
member Item : LogProvider
JScript はインデックス化されたプロパティの使用をサポートしていますが、新規の宣言はサポートしていません。

パラメーター

プロパティ値

型: Microsoft.SqlServer.Dts.Runtime. . :: . .LogProvider
LogProvider オブジェクトです。

例外

例外 条件
DTS_E_ELEMENTNOTFOUND

要素がコレクションに見つかりませんでした。

説明

Contains メソッドの呼び出しが true を返す場合、SelectedLogProviders[index] 構文を使用することにより、コレクション内の指定した要素にアクセスできます。Contains メソッドが false を返す場合、このプロパティは例外をスローします。C# の場合、このプロパティは SelectedLogProviders クラスのインデクサーとなります。

使用例

次のコード例では、コレクションの Contains および Item を [0] 構文で使用する方法の説明に加えて、パッケージのログ プロバイダーの追加と削除を実行します。

using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.SqlServer.Dts.Runtime;

namespace Microsoft.SqlServer.SSIS.Samples
{
    class Program
    {
        static void Main(string[] args)
        {
            Package pkg = new Package();
            // Make several log providers available to the package.
            LogProvider log1 = pkg.LogProviders.Add("DTS.LogProviderEventLog.2");
            LogProvider log2 = pkg.LogProviders.Add("DTS.LogProviderSQLProfiler.2");
            LogProvider log3 = pkg.LogProviders.Add("DTS.LogProviderTextFile.2");
            LogProvider log4 = pkg.LogProviders.Add("DTS.LogProviderTextFile.2");
            // Show the log providers available to the package.
            Console.WriteLine("Log providers available in the Package:");
            LogProviders logs = pkg.LogProviders;
            foreach (LogProvider lp in logs)
                Console.WriteLine(lp.CreationName);

            // Pick a log provider for the package.
            pkg.LoggingOptions.SelectedLogProviders.Add(log4);
            pkg.LoggingOptions.SelectedLogProviders.Add(log1);
            SelectedLogProviders provs = pkg.LoggingOptions.SelectedLogProviders;
            Console.WriteLine();
            Console.WriteLine("Selected Log Providers for Package: {0}", provs.Count);

            foreach (LogProvider lp in provs)
                Console.WriteLine(lp.CreationName);

            pkg.LoggingOptions.SelectedLogProviders.Remove(0);
            Console.WriteLine();
            Console.WriteLine("Count after one has been removed {0}", provs.Count);

            // Test both the indexer and Contains method.
            if (logs.Contains(0))
                Console.WriteLine("Index zero in collection contains:  {0}", logs[0].CreationName);
            else
                throw new Exception();

            // Show the use of the GetEnumerator.
            LogProviderEnumerator myEnum = pkg.LogProviders.GetEnumerator();
            Console.WriteLine("The collection contains the following values:");
            while ((myEnum.MoveNext()) && (myEnum.Current != null))
                Console.WriteLine("{0}", myEnum.Current.Name);
        }
    }
}
Imports System
Imports System.Collections.Generic
Imports System.Text
Imports Microsoft.SqlServer.Dts.Runtime
 
Namespace Microsoft.SqlServer.SSIS.Samples
    Class Program
        Shared  Sub Main(ByVal args() As String)
            Dim pkg As Package =  New Package() 
            ' Make several log providers available to the package.
            Dim log1 As LogProvider =  pkg.LogProviders.Add("DTS.LogProviderEventLog.2") 
            Dim log2 As LogProvider =  pkg.LogProviders.Add("DTS.LogProviderSQLProfiler.2") 
            Dim log3 As LogProvider =  pkg.LogProviders.Add("DTS.LogProviderTextFile.2") 
            Dim log4 As LogProvider =  pkg.LogProviders.Add("DTS.LogProviderTextFile.2") 
            ' Show the log providers available to the package.
            Console.WriteLine("Log providers available in the Package:")
            Dim logs As LogProviders =  pkg.LogProviders 
            Dim lp As LogProvider
            For Each lp In logs
                Console.WriteLine(lp.CreationName)
            Next
 
            ' Pick a log provider for the package.
            pkg.LoggingOptions.SelectedLogProviders.Add(log4)
            pkg.LoggingOptions.SelectedLogProviders.Add(log1)
            Dim provs As SelectedLogProviders =  pkg.LoggingOptions.SelectedLogProviders 
            Console.WriteLine()
            Console.WriteLine("Selected Log Providers for Package: {0}", provs.Count)
 
            Dim lp As LogProvider
            For Each lp In provs
                Console.WriteLine(lp.CreationName)
            Next
 
            pkg.LoggingOptions.SelectedLogProviders.Remove(0)
            Console.WriteLine()
            Console.WriteLine("Count after one has been removed {0}", provs.Count)
 
            ' Test both the indexer and Contains method.
            If logs.Contains(0) Then
                Console.WriteLine("Index zero in collection contains:  {0}", logs(0).CreationName)
            Else 
                Throw New Exception()
            End If
 
            ' Show the use of the GetEnumerator.
            Dim myEnum As LogProviderEnumerator =  pkg.LogProviders.GetEnumerator() 
            Console.WriteLine("The collection contains the following values:")
            While (myEnum.MoveNext()) &&(myEnum.Current <> Nothing)
                Console.WriteLine("{0}", myEnum.Current.Name)
            End While
        End Sub
    End Class
End Namespace

サンプルの出力 :

Log providers available in the Package:

DTS.LogProviderTextFile.2

DTS.LogProviderSQLProfiler.2

DTS.LogProviderEventLog.2

DTS.LogProviderTextFile.2

Selected Log Providers for Package: 2

DTS.LogProviderTextFile.2

DTS.LogProviderEventLog.2

Count after one has been removed 1

Index zero in collection contains: DTS.LogProviderTextFile.2

The collection contains the following values:

{9A4FD6D3-7DE2-43AD-8B02-CE9B02E7504B}

{AB1C156F-8018-4063-A1A5-48E122CE6FFD}

{B8E93B36-36FE-4E65-9814-9752915E9E15}

{E586A867-86EC-4901-8F5A-C945D4469C46}