Package.ExtendedProperties Propiedad

Definición

Espacio de nombres:

Microsoft.SqlServer.Dts.Runtime

Ensamblado:

Microsoft.SqlServer.ManagedDTS.dll

Obtiene la colección ExtendedProperties para el paquete.

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

Valor de propiedad

ExtendedProperties

La colección de objetos ExtendedProperties para el paquete.

Atributos

BrowsableAttribute

Ejemplos

En el ejemplo de código siguiente se muestran algunas de las propiedades extendidas del paquete.

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  

Salida del ejemplo:

{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

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