Supported SQL Server and SSIS Data Types for DQS Domains

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.

[!UWAGA]

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.

In This Topic

• Supported SQL Server Data Types

• Supported SSIS Data Types

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).

[Top]

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.

[Top]

Zobacz także

Inne zasoby

Managing a Domain