Condividi tramite


Package.ExtendedProperties Proprietà

Definizione

Ottiene la raccolta ExtendedProperties per il pacchetto.

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

Valore della proprietà

ExtendedProperties

Raccolta di oggetti ExtendedProperties per il pacchetto.

Attributi

Esempio

Nell'esempio di codice seguente vengono illustrate alcune delle proprietà estese nel pacchetto.

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  

Esempio di output

{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

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

Si applica a