Microsoft SQL Server Connector > Data type reference > Microsoft SQL Server and transformation data types
  

Microsoft SQL Server and transformation data types

The following table lists the Microsoft SQL Server data types that Data Integration supports and the corresponding transformation data types:
Microsoft SQL Server Data Type
Description
Transformation Data Type
Description
Bigint
-9223372036854775808 to 9223372036854775807
Bigint
-9223372036854775808 to 9223372036854775807
Precision 19, Scale 0
Binary
1 to 8000 characters
Binary
1 to 104857600 bytes
Precision 1 to 8000
Bit
0 to 1
Integer
0 to 1
Precision 10, Scale 0
Char
1 to 8000 characters
String
1 to 104857600 characters
Date
0001-01-01 to 9999-12-31
Date/Time
0001-01-01 to 9999-12-31
Precision 29, Scale 9
Datetime
Date range: January 1, 1753 to December 31, 9999
Time range: 00:00:00 to 23:59:59.997
Precision 23, scale 3
Date/Time
Date range: 0001-01-01 to 9999-12-31
Time range: 00:00:00 to 23:59:59.9999999
Precision 29, Scale 9
Datetime2
Date range: 0001-01-01 to 9999-12-31
Time range: 00:00:00 to 23:59:59.9999999
Precision 27, scale 7
Date/Time
Date range: 0001-01-01 to 9999-12-31
Time range: 00:00:00 to 23:59:59.9999999
Precision 29, Scale 9
Decimal(P,S)
Precision 1 to 28, Scale 0 to 28
Decimal
Precision 1 to 28, Scale 0 to 28
Float
-1.79E+308 to 1.79E+308
Double
Precision 15, Scale 0
Int
-2147483648 to 2147483647
Integer
-2147483648 to 2147483647
Precision 10, Scale 0
Money
-922337203685477.5808 to 922337203685477.5807
Decimal
-922337203685477.5808 to 922337203685477.5807
Precision 19, Scale 4
Nchar
1 to 4000 characters
String
1 to 104857600 characters
Ntext
1 to 1073741823 bytes
Text
1 to 104857600 characters
Precision 1 to 32000
Numeric(P,S)
Precision 1 to 28, Scale 0 to 28
Decimal
Precision 1 to 28, Scale 0 to 28
Nvarchar
1 to 4000 characters
String
1 to 104857600 characters
Real
-3.40E+38 to 3.40E+38
Decimal
Precision 7, Scale 0
Smalldatetime
Date range: 1900-01-01 to 2079-06-06
Time range: 00:00:00 to 23:59:59
Date/Time
Date range: 0001-01-01 to 9999-12-31
Time range: 00:00:00 to 23:59:59.9999999
Precision 29, Scale 9
Smallint
-32768 to 32767
Integer
-32768 to 32767
Precision 10, Scale 0
Smallmoney
-214748.3648 to 214748.3647
Decimal
-214748.3648 to 214748.3647
Precision 10, Scale 4
Text
1 to 2147483647 bytes
Text
1 to 104857600 characters
Precision 1 to 32000
Time
00:00:00.0000000 to 23:59:59.9999999
Date/Time
Date range: 0001-01-01 to 9999-12-31
Time range: 00:00:00 to 23:59:59.9999999
Precision 29, Scale 9
Tinyint
0 to 255
Integer
0 to 255
Precision 10, Scale 0
Varbinary
1 to 8000 characters
Binary
1 to 104857600 bytes
Precision 1 to 8000
Varchar
1 to 8000 characters
String
1 to 104857600 characters