Export (0) Print
Expand All

DtsProperty Class

Contains properties and methods used by several containers on their properties. This class cannot be inherited.

Object
  Microsoft.SqlServer.Dts.Runtime.DtsObject
    Microsoft.SqlServer.Dts.Runtime.DtsProperty

Namespace:  Microsoft.SqlServer.Dts.Runtime
Assembly:  Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)

public sealed class DtsProperty : DtsObject

The DtsProperty type exposes the following members.

  NameDescription
Public propertyConnectionTypeReturns the name of the connection manager used to create the connection. This field is read-only.
Public propertyGetReturns a Boolean that indicates whether a property value can be read. This field is read-only.
Public propertyNameReturns the name of the property. This field is read-only.
Public propertyPropertyKindGets the DTSPropertyKind enumeration that contains information about the custom attributes on a property. This information is used by the designer.
Public propertySetReturns a Boolean that indicates whether the referenced object property is changeable. This field is read-only.
Public propertyTypeReturns the data type of the parameter. This field is read-only.
Public propertyTypeConverterReturns the assembly-qualified type name of the type converter object for the property.
Public propertyUITypeEditorReturns the assembly-qualified type name of the graphical editor for the property. This type is read-only.
Top

  NameDescription
Public methodEqualsDetermines whether two object instances are equal. (Inherited from DtsObject.)
Public methodGetExportReturns the export flag for the specified object.
Public methodGetExpressionReturns a String that contains the expression for the specified object. Null means no expression is assigned.
Public methodGetHashCodeReturns the hash code for this instance. (Inherited from DtsObject.)
Public methodGetPackagePathReturns a String that contains the relative path to the location of the specified package.
Public methodGetType (Inherited from Object.)
Public methodGetValueReturns the value of the property.
Public methodSetExportSets the export flag for the specified object.
Public methodSetExpressionAssigns the specified expression to the object. Specify null to remove an existing expression from the property.
Public methodSetValueSets the value of the property.
Public methodToString (Inherited from Object.)
Top

Several containers implement the IDTSPropertiesProvider interface. It provides the inheritors acess to Properties collection, which is a collection of the properties that the container has. It's useful to iterate over this Properties collection instead of accessing each property individually. The Properties collection returns a DtsProperties object, and each individual object in the collection is a DtsProperty object. Because the collection of DtsProperty objects is stored in a DtsProperties collection, you can iterate over the collection using the foreach (For Each in Microsoft Visual Basic) syntax or the PropertyEnumerator and view the properties that this class has.

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft