ForEachEnumeratorHost.Properties Proprietà

Definizione

Spazio dei nomi:

Microsoft.SqlServer.Dts.Runtime

Assembly:

Microsoft.SqlServer.ManagedDTS.dll

Restituisce una raccolta DtsProperties contenente oggetti DtsProperty. Ogni oggetto DtsProperty dispone di informazioni aggiuntive su ciascuna attività in ForEachEnumeratorHost.

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

public Microsoft.SqlServer.Dts.Runtime.DtsProperties Properties { get; }

member this.Properties : Microsoft.SqlServer.Dts.Runtime.DtsProperties

Public ReadOnly Property Properties As DtsProperties

Valore della proprietà

DtsProperties

Raccolta DtsProperties.

Implementazioni

Properties

Esempio

Nell'esempio ForEachEnumeratorHostdi codice seguente viene ospitato un ForEachSMOEnumerator oggetto in , quindi viene visualizzata la raccolta delle proprietà dell'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  

Esempio di output

Property Name CollectionEnumerator, Type Boolean

Nome proprietà CreationName, Tipo String

Descrizione nome proprietà, tipo stringa

Nome proprietà EnumURN, Tipo Stringa

ID nome proprietà, tipo stringa

Nome proprietà, Tipo Stringa

Nome proprietà versione, digitare Int32