Package.ExtendedProperties Package.ExtendedProperties Package.ExtendedProperties Property

Definition

Gets the ExtendedProperties collection for the package.

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; }
Public ReadOnly Property ExtendedProperties As ExtendedProperties
Property Value

Examples

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

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

Applies to