United States (English)

Home Library Learn Samples Downloads Support Community Forums

MSDN Library

Servers and Enterprise Development

SQL Server

SQL Server 2012

Product Documentation

Developer Reference for SQL Server 2012

Developer Reference

Developer's Guide (Integration Services)

Microsoft.SqlServer.Dts.Runtime

ActionOnExistType Enumeration

Application Class

BatchUpgradeOptions Class

BreakpointManager Class

BreakpointTarget Class

BreakpointTargetEnumerator Class

BreakpointTargets Class

Configuration Class

ConfigurationEnumerator Class

Configurations Class

ConnectionEnumerator Class

ConnectionInfo Class

ConnectionInfoEnumerator Class

ConnectionInfos Class

ConnectionManager Class

ConnectionManagerBase Class

ConnectionManagerItem Class

ConnectionManagerItems Class

ConnectionManagerItemState Enumeration

Connections Class

DataTypeInfo Class

DataTypeInfoEnumerator Class

DataTypeInfos Class

DBProviderInfo Class

DBProviderInfoEnumerator Class

DBProviderInfos Class

DefaultEvents Class

DTSBreakpointHitTest Enumeration

DTSCheckpointUsage Enumeration

DtsComException Class

DtsComponentException Class

DTSConfigurationType Enumeration

DtsConnectionAttribute Class

DtsConnectionException Class

DTSConnectionManagerScope Enumeration

DtsContainer Class

DtsConvert Class

DtsCouldNotCreateManagedConnectionException Class

DtsCouldNotCreateManagedForEachEnumeratorException Class

DtsEnumerator Class

DtsErrors Class

DTSEventColumnFilter Structure

DTSEventFilterKind Enumeration

DtsEventHandler Class

DtsEventHandlerEnumerator Class

DtsEventHandlers Class

DtsException Class

DTSExecResult Enumeration

DTSExecStatus Enumeration

DTSExecutionLocation Enumeration

DtsExponentTooLargeException Class

DTSFileConnectionUsageType Enumeration

DTSForcedExecResult Enumeration

DtsForEachEnumeratorAttribute Class

DtsGenericException Class

DtsInvalidBreakpointSiteException Class

DtsInvalidProjectPasswordOrDataException Class

DtsInvalidProjectUserKeyOrDataException Class

DTSLogEntryFrequency Enumeration

DTSLoggingMode Enumeration

DtsLogProviderAttribute Class

DTSManagedXmlSerializationHelper Class

DtsNoConnectionAssignedException Class

DtsNoForEachEnumAssignedException Class

DtsNoLogProviderAssignedException Class

DtsNoObjectAssignedException Class

DtsNotAConnectionException Class

DtsNotAForEachEnumException Class

DtsNotALogProviderException Class

DtsNotAManagedEnumeratorException Class

DtsNoTaskAssignedException Class

DtsNotATaskException Class

DtsObject Class

DTSObjectHostType Enumeration

DTSObjectReferenceType Enumeration

DTSPackageInfoFlags Enumeration

DTSPackageType Enumeration

DTSPipelineComponentType Enumeration

DtsPipelineException Class

DTSPrecedenceEvalOp Enumeration

DTSPriorityClass Enumeration

DTSProductLevel Enumeration

DtsProperties Class

DtsProperty Class

DtsPropertyAttribute Class

DTSPropertyKind Enumeration

DTSProtectionLevel Enumeration

DTSProviderSubType Enumeration

DTSProviderType Enumeration

DTSReadOnlyCollectionBase Class

DtsRuntimeException Class

DtsScriptingException Class

DTSServerParameterType Enumeration

DTSSignatureStatus Enumeration

DtsSqlException Class

DtsTaskAttribute Class

DtsTaskException Class

DtsToolsException Class

DTSTransactionOption Enumeration

DtsWarning Class

DtsWarnings Class

EmptyEnumerator Class

EnumReferencedObjects Class

ErrorEnumerator Class

EventInfo Class

EventInfoEnumerator Class

EventInfos Class

EventsProvider Class

Executable Class

ExecutableEnumerator Class

Executables Class

ExtendedProperties Class

ExtendedProperty Class

ExtendedPropertyEnumerator Class

FlatFileColumn Class

ForEachEnumerator Class

ForEachEnumeratorHost Class

ForEachEnumeratorInfo Class

ForEachEnumeratorInfos Class

ForEachEnumeratorInfosEnumerator Class

ForEachEnumeratorUI Class

ForEachLoop Class

ForEachVariableMapping Class

ForEachVariableMappingEnumerator Class

ForEachVariableMappings Class

ForLoop Class

FtpClientConnection Class

HttpClientConnection Class

IDTSBreakpointSite Interface

IDTSComponentEvents Interface

IDTSComponentPersist Interface

IDTSConfigurationControl Interface

IDTSDowngradableObject Interface

IDTSDumpConfiguration Interface

IDTSEvents Interface

IDTSExecutionMetrics Interface

IDTSExecutionPath Interface

IDTSForEachEnumerator Interface

IDTSForEachEnumeratorUI Interface

IDTSInfoEvents Interface

IDTSLogging Interface

IDTSManagedTask Interface

IDTSName Interface

IDTSObjectHost Interface

IDTSPackageInternal Interface

IDTSPackagePath Interface

IDTSPersist Interface

IDTSPropertiesProvider Interface

IDTSPropertiesProviderEx Interface

IDTSSequence Interface

IDTSSuspend Interface

LogEntryInfo Class

LogEntryInfoEnumerator Class

LogEntryInfos Class

LoggingOptions Class

LogProvider Class

LogProviderBase Class

LogProviderEnumerator Class

LogProviderInfo Class

LogProviderInfoEnumerator Class

LogProviderInfos Class

LogProviders Class

ManagedForEachEnumeratorWrapper Class

ManagedHelper Class

ManagedHelper.ManagedPropertyHelper Class

ManagedWrapper Class

ManagerSerializer Class

NameChecker Class

NameCheckResult Enumeration

ObjectReferenceTracker Class

Package Class

PackageInfo Class

PackageInfoEnumerator Class

PackageInfos Class

PackageItem Class

PackageItems Class

PackageItemState Enumeration

PackageParameterEnumerator Class

PackageUpgradeOptions Class

PackageUpgradeResult Class

Parameter Class

ParameterInfo Class

ParameterInfos Class

Parameters Class

PipelineComponentInfo Class

PipelineComponentInfoEnumerator Class

PipelineComponentInfos Class

PrecedenceConstraint Class

PrecedenceConstraintEnumerator Class

PrecedenceConstraints Class

Project Class

Project.AccessMode Enumeration

ProjectStorageAttributes Enumeration

ProjectVariablesWrapper Class

PropertyEnumerator Class

RunningPackage Class

RunningPackages Class

RunningPackagesEnumerator Class

SelectedLogProviders Class

SsisServerExecution Class

StatusMessage Structure

StorageInfo Class

StorageType Enumeration

Task Class

TaskInfoEnumerator Class

TaskInfos Class

UpgradePackageInfo Class

UpgradeResult Class

UpgradeResultStatus Enumeration

VariableDispenser Class

VariableEnumerator Class

Variables Class

WarningEnumerator Class

Minimize

This topic has not yet been rated - Rate this topic

DTSPropertyKind Enumeration

SQL Server 2012

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

	Member name	Description
	Connection	The property is a connection.
	Other	The property is not described by any of the available enumerations.
	Sensitive	The property is sensitive.
	VariableReadOnly	The property is a read-only variable.
	VariableReadWrite	The 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\100\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);
        }
    }

Reference

Microsoft.SqlServer.Dts.Runtime Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft. All rights reserved.