Properties 속성

Returns a DtsProperties collection that contains DtsProperty objects. Each DtsProperty has additional information about each task in the ForEachEnumeratorHost.

네임스페이스:  Microsoft.SqlServer.Dts.Runtime
어셈블리:  Microsoft.SqlServer.ManagedDTS.dll의 Microsoft.SqlServer.ManagedDTS

구문

‘선언
Public ReadOnly Property Properties As DtsProperties
    Get
‘사용 방법
Dim instance As ForEachEnumeratorHost
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
A DtsProperties collection.

구현

IDTSPropertiesProvider. . :: . .Properties

예제

The following code example hosts a ForEachSMOEnumerator in the ForEachEnumeratorHost, then displays the properties collection of the host.

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

namespace Microsoft.SqlServer.SSIS.Sample
{
    internal class EnumType
    {
        public const string SMOEnum = "Foreach SMO Enumerator";
    }
        class Program
        {
            static void Main(string[] args)
            {
                Application app = new Application();

                ForEachEnumeratorInfos infos = app.ForEachEnumeratorInfos;
                ForEachEnumeratorInfo info = null;
                foreach (ForEachEnumeratorInfo enumInfo in infos)
                {
                    if (enumInfo.Name == EnumType.SMOEnum)
                        {
                            info = enumInfo;
                        }
                }
                ForEachEnumeratorHost enumH = info.CreateNew();
                DtsProperties hostProps = enumH.Properties;

                // Display the name and type of properties in the collection.
                foreach (DtsProperty prop in hostProps)
            {
                Console.WriteLine("Property Name {0}, Type {1}", prop.Name, prop.Type);
                //Console.WriteLine("Property Type {0}", prop.Type);
            }

            ForEachSMOEnumerator smoEnumerator = (ForEachSMOEnumerator)enumH.InnerObject;
        }
    }
}

Imports System
Imports System.Collections.Generic
Imports System.Text
Imports Microsoft.SqlServer.Dts.Runtime.Enumerators.SMO
Imports Microsoft.SqlServer.Dts.Runtime
 
Namespace Microsoft.SqlServer.SSIS.Sample
    Friend Class EnumType
        Public const String SMOEnum = "Foreach SMO Enumerator"
    End Class
        Class Program
            Shared  Sub Main(ByVal args() As String)
                Dim app As Application =  New Application() 
 
                Dim infos As ForEachEnumeratorInfos =  app.ForEachEnumeratorInfos 
                Dim info As ForEachEnumeratorInfo =  Nothing 
                Dim EnumInfo As ForEachEnumeratorInfo 
                Dim enumInfo As ForEachEnumeratorInfo
                End Enum
                For Each EnumInfo In infos 
                For Each EnumInfo In infos 
                For Each EnumInfo In infos If EnumInfo.Name = EnumType.SMOEnum Then info = EnumInfo End Enum End Enum 
                For Each enumInfo In infos
                    If enumInfo.Name = EnumType.SMOEnum Then
                            info = enumInfo
                End Enum
                End Enum
                End Enum
                    End If
                Next
                Dim EnumH As ForEachEnumeratorHost =  info.CreateNew() 
                Dim enumH As ForEachEnumeratorHost =  info.CreateNew() 
                End Enum
                Dim hostProps As DtsProperties =  EnumH.Properties 
                Dim hostProps As DtsProperties =  enumH.Properties 
                End Enum
 
                ' Display the name and type of properties in the collection.
                Dim prop As DtsProperty
                For Each prop In hostProps
                Console.WriteLine("Property Name {0}, Type {1}", prop.Name, prop.Type)
                'Console.WriteLine("Property Type {0}", prop.Type);
                Next
 
            Dim smoEnumerator As ForEachSMOEnumerator = CType(EnumH.InnerObject, ForEachSMOEnumerator)
            Dim smoEnumerator As ForEachSMOEnumerator = CType(enumH.InnerObject, ForEachSMOEnumerator)
            End Enum
            End Sub
        End Class
End Namespace

Sample Output:

Property Name CollectionEnumerator, Type Boolean

Property Name CreationName, Type String

Property Name Description, Type String

Property Name EnumURN, Type String

Property Name ID, Type String

Property Name Name, Type String

Property Name Version, Type Int32

참고 항목

참조

ForEachEnumeratorHost 클래스

ForEachEnumeratorHost 멤버

Microsoft.SqlServer.Dts.Runtime 네임스페이스