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

DTSPropertyKind Enumeration

Contains values that describe the type of property.

Namespace: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)
public enum DTSPropertyKind
public enum DTSPropertyKind
public enum DTSPropertyKind
Member nameDescription
ConnectionThe property is a connection.
OtherThe property is not described by any of the available enumerations.
SensitiveThe property is sensitive.
VariableReadOnlyThe property is a read-only variable.
VariableReadWriteThe property is a read/write variable.

The following code sample shows how to retrieve the property kind for a specific property.

static void Main(string[] args)
        // The variable pkg points to the location
        // of the ExecuteProcess package sample 
        // that is installed with the SSIS samples.
        string packageFile = @"C:\Program Files\Microsoft SQL Server\90\Samples\Integration Services\Package Samples\ExecuteProcess Sample\ExecuteProcess\UsingExecuteProcess.dtsx";

        Application application = new Application();
        Package package = application.LoadPackage(packageFile, null);

        // Retrieve the information from the Properties collection.
        // Each item in the collection represents a property on the
        // object. This example reviews the properties of the 
        // Package object.

        DtsProperties properties = package.Properties;

        String propertyName;
        DTSPropertyKind propertyKind;
        String packagePath;
        TypeCode propertyType;

        foreach (DtsProperty property in properties)
            propertyType = property.Type;
            propertyName = property.Name;
            propertyKind = property.PropertyKind;
            packagePath = property.GetPackagePath(package);
            Console.WriteLine("Property Type: {0}, Property Name: {1}, Property Kind: {2}, Package Path: {3} ", 
            propertyType, propertyName, propertyKind, packagePath);

Development Platforms

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

Target Platforms

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2014 Microsoft. All rights reserved.