CManagedComponentWrapperClass.SetOutputColumnDataTypeProperties Method

Reference

Definition

Namespace:: Microsoft.SqlServer.Dts.Pipeline.Wrapper.Sql2012

Assembly:: Microsoft.SqlServer.DTSPipelineWrap.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

public:
 virtual void SetOutputColumnDataTypeProperties(int lOutputID, int lOutputColumnID, Microsoft::SqlServer::Dts::Runtime::Wrapper::Sql2012::DataType eDataType, int lLength, int lPrecision, int lScale, int lCodePage) = Microsoft::SqlServer::Dts::Pipeline::Wrapper::Sql2012::IDTSDesigntimeComponent100::SetOutputColumnDataTypeProperties;

[System.Runtime.InteropServices.DispId(32)]
public virtual void SetOutputColumnDataTypeProperties (int lOutputID, int lOutputColumnID, Microsoft.SqlServer.Dts.Runtime.Wrapper.Sql2012.DataType eDataType, int lLength, int lPrecision, int lScale, int lCodePage);

[<System.Runtime.InteropServices.DispId(32)>]
abstract member SetOutputColumnDataTypeProperties : int * int * Microsoft.SqlServer.Dts.Runtime.Wrapper.Sql2012.DataType * int * int * int * int -> unit
override this.SetOutputColumnDataTypeProperties : int * int * Microsoft.SqlServer.Dts.Runtime.Wrapper.Sql2012.DataType * int * int * int * int -> unit

Public Overridable Sub SetOutputColumnDataTypeProperties (lOutputID As Integer, lOutputColumnID As Integer, eDataType As DataType, lLength As Integer, lPrecision As Integer, lScale As Integer, lCodePage As Integer)

Parameters

lOutputID: Int32

lOutputColumnID: Int32

eDataType: DataType

lLength: Int32

lPrecision: Int32

lScale: Int32

lCodePage: Int32

Implements

SetOutputColumnDataTypeProperties(Int32, Int32, DataType, Int32, Int32, Int32, Int32)

Attributes: DispIdAttribute

Remarks

The data type properties of an output column are dependent on each other and require that specific rules be followed based on the DataType of the column. This method enables a component to enforce these rules by setting all of the properties at once.

The following table lists the rules that apply when setting the data type properties of an output column.

DataType	Length	Scale	Precision	CodePage
DT_DECIMAL	0	Greater than 0 and less than or equal to 28.	0	0
DT_CY	0	0	0	0
DT_NUMERIC	0	Greater than 0 and less than or equal to 28 and less than Precision.	Greater than or equal to 1 and less than or equal to 38.	0
DT_BYTES	Greater than 0.	0	0	0
DT_STR	Greater than 0 and less than 8000.	0	0	Not 0, and a valid code page.
DT_TEXT	Greater than 0 and less than 8000.	0	0	Not 0, and a valid code page.
DT_WSTR	Greater than 0 and less than 4000.	0	0	0

Applies to

共用方式為