Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Package.ExtendedProperties Property

Returns the ExtendedProperties collection for the package.

Namespace: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)
public ExtendedProperties ExtendedProperties { get; }
/** @property */
public ExtendedProperties get_ExtendedProperties ()

public function get ExtendedProperties () : ExtendedProperties

Property Value

An ExtendedProperties collection.

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\90\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);

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


Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

Community Additions

© 2014 Microsoft. All rights reserved.