Condividi tramite

  • Articolo

Proprietà ExtendedProperties

Returns the ExtendedProperties collection for the package.

Spazio dei nomi  Microsoft.SqlServer.Dts.Runtime
Assembly:  Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)

Sintassi

'Dichiarazione
<BrowsableAttribute(False)> _
Public ReadOnly Property ExtendedProperties As ExtendedProperties
    Get
'Utilizzo
Dim instance As Package
Dim value As ExtendedProperties

value = instance.ExtendedProperties

[BrowsableAttribute(false)]
public ExtendedProperties ExtendedProperties { get; }

[BrowsableAttribute(false)]
public:
property ExtendedProperties^ ExtendedProperties {
    ExtendedProperties^ get ();
}

[<BrowsableAttribute(false)>]
member ExtendedProperties : ExtendedProperties

function get ExtendedProperties () : ExtendedProperties

Esempi

The following code example shows some of the extended properties in the package.

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

Sample 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

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