DTS Programming

DataType Property

The DataType property specifies the data type of a Column object.

Applies To

Syntax

object.DataType [= value]

Part	Description
object	Expression that evaluates to a Column object
value	Column data type

Data Type

Long

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetDataType(LONG *pRetVal);

HRESULT SetDataType(LONG NewValue);

Remarks

Data Transformation Services (DTS) column data types match those used in Microsoft® ActiveX® Data Objects (ADO), both in name and value, and OLE DB type identifiers (DBTYPEs).

You can find the valid values for the DataType property by searching for DBTYPEENUM in the include file OLEDB.h. OLEDB.h is installed in c:\Program Files\Microsoft SQL Server\80\Tools\DevTools\include\ by default.