TechNet
Export (0) Print
Expand All

Supported SQL Server and SSIS Data Types for DQS Domains

 

Updated: November 9, 2011

Applies To: SQL Server 2016

There are many data types in SQL Server and SQL Server Integration Services (SSIS), but only four data types for DQS domains: Date, Decimal, Integer, and String. Not all SQL Server and SSIS data types are supported in DQS. You can map your source data to a DQS domain for performing data-quality activities only if the source data type is supported in DQS, and matches with the DQS domain data type. This topic provides information about the SQL Server and SSIS data types that are supported, and available for mapping to each of the four domain data types in DQS.

System_CAPS_noteNote

In .xlsx and .xls files, the data type of the source column is determined by the most prevalent data type in the first eight rows. If a cell does not conform to that data type, it will be given a null value. Similarly, in .csv files, the data type of the source column is determined by the most prevalent data type in the first eight rows.

The following table provides information about the SQL Server data types supported for each DQS domain data type:

DQS Domain Data Type

Supported SQL Server Data Type

Date

date

Decimal

decimal

float

money

numeric

real

smallmoney

Integer

bigint

int

smallint

tinyint

String

char

nchar

nvarchar

varchar

Rest of the SQL Server data types are not supported in DQS. For information about all the SQL Server data types, see Data Types (Transact-SQL).

The following table provides information about the SSIS data types supported for each DQS domain data type:

DQS Domain Data Type

Supported SSIS Data Type

Date

DT_DATE

Decimal

DT_DECIMAL

DT_NUMERIC

DT_R4

DT_R8

Integer

DT_I1

DT_I2

DT_I4

DT_I8

DT_U1

DT_U2

DT_U4

DT_U8

String

DT_STR

DT_WSTR

Rest of the SSIS data types are not supported in DQS. For information about all the SSIS data types, see Integration Services Data Types.

Community Additions

ADD
Show:
© 2016 Microsoft