DTS Programming
DataType Property
The DataType property specifies the data type of a Column object.
Applies To
| Column Object |
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.