次の方法で共有

  • [アーティクル]

Properties プロパティ

DtsProperty オブジェクトのコレクションを含む DtsProperties コレクションを返します。

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

構文

'宣言
Public ReadOnly Property Properties As DtsProperties
    Get
'使用
Dim instance As LogProvider
Dim value As DtsProperties

value = instance.Properties

public DtsProperties Properties { get; }

public:
virtual property DtsProperties^ Properties {
    DtsProperties^ get () sealed;
}

abstract Properties : DtsProperties
override Properties : DtsProperties

final function get Properties () : DtsProperties

プロパティ値

型: Microsoft.SqlServer.Dts.Runtime. . :: . .DtsProperties
DtsProperties コレクションです。

実装

IDTSPropertiesProvider. . :: . .Properties

使用例

次の例では、パッケージ内のログ プロバイダの Properties を取得します。サンプル パッケージは、[テキスト ファイルの SSIS ログ プロバイダ] にログを記録するために読み込む前に、デザイナで変更されています。

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

namespace LogProvider_Properties_Test
{
    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 LogProviders collection.
            LogProviders logProvs = pkg.LogProviders;

            // Get the "SSIS log provider for Text files"
            // provider from the collection.
            LogProvider textLogProv = logProvs["SSIS log provider for Text files"];

            // Get the Properties collection from the Text provider,
            // and iterate through the Text provider properties,  
            // printing the property names of the Text provider.
            DtsProperties logProperties = textLogProv.Properties;

            foreach (DtsProperty logProp in logProperties)
                Console.WriteLine(logProp.Name);
                
        }
    }
}

Imports System
Imports System.Collections.Generic
Imports System.Text
Imports Microsoft.SqlServer.Dts.Runtime
 
Namespace LogProvider_Properties_Test
    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 LogProviders collection.
            Dim logProvs As LogProviders =  pkg.LogProviders 
 
            ' Get the "SSIS log provider for Text files"
            ' provider from the collection.
            Dim textLogProv As LogProvider =  logProvs("SSIS log provider for Text files") 
 
            ' Get the Properties collection from the Text provider,
            ' and iterate through the Text provider properties,  
            ' printing the property names of the Text provider.
            Dim logProperties As DtsProperties =  textLogProv.Properties 
 
            Dim logProp As DtsProperty
            For Each logProp In logProperties
                Console.WriteLine(logProp.Name)
            Next
 
        End Sub
    End Class
End Namespace

サンプルの出力 :

ConfigString

CreationName

Description

Enabled