Provider Information MsSQL Column Type Information: smallint (I2) (size 5) (isfixedlength) (isautoincriment) (best) int (I4) (size 10) (isfixedlength) (isautoincriment) (best) real (R4) (size 7) (isfixedlength) (best) float (R8) (size 15) (isfixedlength) (best) money (CY) (size 19) (isfixedlength) (best) smallmoney (CY) (size 10) (isfixedlength) bit (BOOL) (size 1) (isfixedlength) (best) sql_variant (VARIANT) (size 16) (isfixedlength) (best) tinyint (UI1) (size 3) (isfixedlength) (isautoincriment) (best) bigint (I8) (size 19) (isfixedlength) (isautoincriment) (best) uniqueidentifier (GUID) (size 16) (isfixedlength) (best) image (BYTES) (size 2147483647) (islong) varbinary (BYTES) (size 8000) (max length) (best) binary (BYTES) (size 8000) (isfixedlength) (length) timestamp (BYTES) (size 8) (isfixedlength) char (STR) (size 8000) (isfixedlength) (length) varchar (STR) (size 8000) (max length) (best) text (STR) (size 2147483647) (islong) ntext (WSTR) (size 1073741823) (islong) nvarchar (WSTR) (size 4000) (max length) (best) nchar (WSTR) (size 4000) (isfixedlength) (length) decimal (NUMERIC) (size 38) (isfixedlength) (isautoincriment) (precision,scale) numeric (NUMERIC) (size 38) (isfixedlength) (isautoincriment) (precision,scale) (best) date (DBDATE) (size 10) (isfixedlength) (best) smalldatetime (DBTIMESTAMP) (size 16) (isfixedlength) datetime2 (DBTIMESTAMP) (size 27) (isfixedlength) (scale) (best) datetime (DBTIMESTAMP) (size 23) (isfixedlength) xml () (islong) (best) time () (size 16) (isfixedlength) (scale) (best) datetimeoffset () (size 34) (isfixedlength) (scale) (best) This list can be created for any initialized source, by choosing [Admin/DBMS data types] and copying from the Results tab.