Handling SQL Server data types
The ODBC stage can handle the GUID, Timestamp, and SmallDateTime SQL Server data types.
- GUID type
If you imported column metadata from a SQL Server data source that contains GUID types, load the required table definition on the Columns tab. If you specify the table definition manually, you must configure the column that you want to contain a GUID data type. - Timestamp type
Timestamp data types cannot be handled automatically by importing the SQL Server metadata. They always need to be set up manually - SmallDateTime type
If you imported column metadata from an SQL Server data source that contains SmallDateTime types, load the required table definition on the Columns tab. If you specify the table definition manually, you must configure the column that you want to contain a SmallDateTime data type.
Parent topic: ODBC stage