Supported SQL Server and SSIS data types for DQS Domains
Applies to:
SQL Server
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.
Note
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.
Supported SQL Server Data Types
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).
Supported SSIS Data Types
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.