The Teradata Aster SSIS Connector uses Aster Export Source to provide special-value handling when mapping certain Aster Database types to SSIS (see the table below):
- NaN
- -/+Infinity
- Out-of-range values
Special-value handling (Aster Export Source) Aster SSIS Special Values Out-of-Range Real DT_R4 NaN, +/- Infinity Double DT_R8 NaN, +/- Infinity Numeric DT_R8/DT_Decimal/DT_Numeric NaN Date DT_DBDATE +/- Infinity < 0001-01-01 (with “BC”) > 9999-12-31 Timestamp DT_TIMESTAMP2 +/- Infinity < 0001-01-01 (with “BC”) > 9999-12-31 Timestamptz DT_DATETIMESTAMPOFFSET +/- Infinity < 0001-01-01 (with “BC”) > 9999-12-31
For more information, see Configuring Special Value Settings.