Table of Contents

Search

  1. Preface
  2. Using the Designer
  3. Working with Sources
  4. Working with Flat Files
  5. Working with Targets
  6. Mappings
  7. Mapplets
  8. Mapping Parameters and Variables
  9. Working with User-Defined Functions
  10. Using the Debugger
  11. Viewing Data Lineage
  12. Comparing Objects
  13. Managing Business Components
  14. Creating Cubes and Dimensions
  15. Using the Mapping Wizards
  16. Datatype Reference
  17. Configure the Web Browser

ODBC and Transformation Datatypes

ODBC and Transformation Datatypes

The following table compares ODBC datatypes, such as Microsoft Access or Excel, to transformation datatypes:
Datatype
Transformation
Range
Bigint
Bigint
-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807
Precision 19, scale 0
Binary
Binary
1 to 104,857,600 bytes
Bit
String
1 to 104,857,600 characters
Char(L)
String
1 to 104,857,600 characters
Date
Date/Time
Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
(precision to the nanosecond)
Decimal(P, S)
Decimal
Precision 1 to 28, scale 0 to 28
Double
Double
Precision 15
Float
Double
Precision 15
Integer
Integer
-2,147,483,648 to 2,147,483,647
Precision 10, scale 0
Long Varbinary
Binary
1 to 104,857,600 bytes
Nchar
Nstring
1 to 104,857,600 characters
Nvarchar
Nstring
1 to 104,857,600 characters
Ntext
Ntext
1 to 104,857,600 characters
Numeric
Decimal
Precision 1 to 28, scale 0 to 28
Real
Real
Precision 7, scale 0
Smallint
Smallint
Precision 5, scale 0
Text
Text
1 to 104,857,600 characters
Time
Date/Time
Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
(precision to the nanosecond)
Timestamp
Date/Time
Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
(precision to the nanosecond)
Tinyint
Small Integer
Precision 5, scale 0
Varbinary
Binary
1 to 104,857,600 bytes
Varchar(L)
String
1 to 104,857,600 characters
When the Integration Service runs in Unicode data movement mode, the column precision that you specify for ODBC datatypes determines the number of characters the Integration Service reads and writes.


Updated July 02, 2020