DTSUsageType Enumeration

Indicates how an IDTSInputColumn100 object is used by a component.

Namespace:  Microsoft.SqlServer.Dts.Pipeline.Wrapper
Assembly:  Microsoft.SqlServer.DTSPipelineWrap (in Microsoft.SqlServer.DTSPipelineWrap.dll)

public enum DTSUsageType

Member nameDescription
UT_READONLYThe component will read the values of an input column, but will not modify them.
UT_READWRITEThe component will read and write to the column data.
UT_IGNOREDThe column is ignored by the component.

This enumeration contains values that indicate how a component will use an IDTSInputColumn100 object.

Components validate that each column in their IDTSInputColumnCollection100 has its UsageType property set correctly.

For example, if a component needs read/write permission to an input column and the column's UsageType property is set to UT_READONLY, it should post a DTS_E_CANTSETUSAGETYPE message and return a failure result from Validate.

Community Additions