Package.ExtendedProperties Property

Definition

Namespace:

Microsoft.SqlServer.Dts.Runtime

Assembly:

Microsoft.SqlServer.ManagedDTS.dll

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; }

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

Public ReadOnly Property ExtendedProperties As ExtendedProperties

Property Value

ExtendedProperties

The ExtendedProperties object collection for the package.

Attributes

BrowsableAttribute

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

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