Connectors > MS SQL Server

MSSQL Type	DTS Type
bigint	INT64
int	INT32
smallint	INT16
tinyint	UNSIGNED_INT8
numeric	DECIMAL
decimal	DECIMAL
money	DECIMAL
smallmoney	DECIMAL
bit	BOOLEAN
float	DOUBLE
real	DOUBLE
date	DATE
datetime	DATE_TIME
datetime2	DATE_TIME
smalldatetime	DATE_TIME
datetimeoffset	DATE_TIME
time	TIME
char	STRING
nchar	STRING
varchar	STRING
nvarchar	STRING
text	STRING
ntext	STRING
binary	BINARY
varbinary	BINARY
image	BINARY
uniqueidentifier	STRING
xml	STRING
geometry	DTS_GEOMETRY
geography	DTS_GEOGRAPHY

User Types are fully supported and mapped as their underlying native type.

Table Types are also fully supported and mapped as DTS objects which reflect the table type's column structure. When they are used as arguments, they take the form of arrays with the respective row element type.

Currently Unsupported Native Types:

cursor, rowversion, hierarchyid, sqlvariant