Package.ExtendedProperties Свойство

Определение

Пространство имен:

Microsoft.SqlServer.Dts.Runtime

Сборка:

Microsoft.SqlServer.ManagedDTS.dll

Возвращает коллекцию ExtendedProperties для пакета.

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

[System.ComponentModel.Browsable(false)]
public Microsoft.SqlServer.Dts.Runtime.ExtendedProperties ExtendedProperties { get; }

[<System.ComponentModel.Browsable(false)>]
member this.ExtendedProperties : Microsoft.SqlServer.Dts.Runtime.ExtendedProperties

Public ReadOnly Property ExtendedProperties As ExtendedProperties

Значение свойства

ExtendedProperties

Коллекция объектов ExtendedProperties для пакета.

Атрибуты

BrowsableAttribute

Примеры

В следующем примере кода показаны некоторые расширенные свойства в пакете.

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

namespace Package_API  
{  
    class Program  
    {  
        static void Main(string[] args)  
        {  
            Application app = new Application();  
            Package pkg = new Package();  
            pkg = app.LoadPackage(@"C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services\Package Samples\CalculatedColumns Sample\CalculatedColumns\CalculatedColumns.dtsx", null);  
            // Get the extended properties.  
            ExtendedProperties extProps = pkg.ExtendedProperties;  

            // Iterate through the extended properties.  
            foreach (ExtendedProperty exProp in extProps)  
            {  
                Console.WriteLine("{0}, {1}", exProp.ID, exProp.DataType);  
                Console.WriteLine("--------------------------------");  
            }  
        }  
    }  
}  

Imports System  
Imports System.Collections.Generic  
Imports System.Text  
Imports Microsoft.SqlServer.Dts.Runtime  
Imports Microsoft.SqlServer.Dts.Tasks.ScriptTask  

Namespace Package_API  
    Class Program  
        Shared  Sub Main(ByVal args() As String)  
            Dim app As Application =  New Application()   
            Dim pkg As Package =  New Package()   
            pkg = app.LoadPackage("C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services\Package Samples\CalculatedColumns Sample\CalculatedColumns\CalculatedColumns.dtsx", Nothing)  
            ' Get the extended properties.  
            Dim extProps As ExtendedProperties =  pkg.ExtendedProperties   

            ' Iterate through the extended properties.  
            Dim exProp As ExtendedProperty  
            For Each exProp In extProps  
                Console.WriteLine("{0}, {1}", exProp.ID, exProp.DataType)  
                Console.WriteLine("--------------------------------")  
            Next  
        End Sub  
    End Class  
End Namespace  

Образец вывода:

{4CBE9BFD-9218-4027-A1EA-EF3BAB585B99}, String

--------------------------------

{F50BF3C3-4077-479B-A946-CDC297ADC5D3}, String

--------------------------------

{89E1F3B4-935E-4221-8BD3-36251C853180}, String

--------------------------------

{74E2710F-B94C-4D18-8531-0C0A7D906924}, String

--------------------------------

{9C863EB8-B14D-4A73-B95E-1FB1A7348F40}, String

--------------------------------

{6AE87DC6-FEDC-458B-AEFC-61BCA27FE2CF}, String

--------------------------------

{D667DF92-65D7-4468-8B75-FFDB2206B911}, String

--------------------------------