DTSPropertyKind Enumeration
Contains values that describe the type of property.
Namespace: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)
Syntax
'Declaration
Public Enumeration DTSPropertyKind
'Usage
Dim instance As DTSPropertyKind
public enum DTSPropertyKind
public enum class DTSPropertyKind
type DTSPropertyKind
public enum DTSPropertyKind
Members
| 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. |
Examples
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);
}
}
Shared Sub Main(ByVal args() As String)
' The variable pkg points to the location
' of the ExecuteProcess package sample
' that is installed with the SSIS samples.
Dim packageFile As String = "C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services\Package Samples\ExecuteProcess Sample\ExecuteProcess\UsingExecuteProcess.dtsx"
Dim application As Application = New Application()
Dim package As Package = application.LoadPackage(packageFile,Nothing)
' 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.
Dim properties As DtsProperties = package.Properties
Dim propertyName As String
Dim propertyKind As DTSPropertyKind
Dim packagePath As String
Dim propertyType As TypeCode
Dim property As DtsProperty
For Each 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)
Next
End Sub