The Special Value pane is where you specify special value handling.
Name | Description |
---|---|
Output Column | Name of the exported column. It is the same as External Column, but you can choose to ignore this column. |
External Column | Name of the column in Aster Database. This is a read-only field. |
NaN Method | If the column contains NaN, you can choose one of these handling methods: Not Used: Pass the value directly to SSIS without modification. In this case, mapping errors and value truncation is reported to SSIS, which applies the appropriate error or truncation handling method (Redirect, Ignore, or FailComponent). Insert Null: Insert Null in place of NaN. User defined: Insert a user-defined value in place of NaN. |
NaN UD Value | The user-defined value to use in place of NaN. |
PosInf Method | If the column contains positive infinity, you can choose one of these handling methods: Not Used: Pass the value directly to SSIS without modification. In this case, mapping errors and value truncation is reported to SSIS, which applies the appropriate error or truncation handling method (Redirect, Ignore, or FailComponent). Insert Null: Insert Null in place of positive infinity. User defined: Insert a user-defined value in place of positive infinity. |
PosInf UD Value | The user-defined value to use in place of positive infinity. |
NegInf Method | If the column contains negative infinity, you can choose one of these handling methods: Not Used: Pass the value directly to SSIS without modification. In this case, mapping errors and value truncation is reported to SSIS, which applies the appropriate error or truncation handling method (Redirect, Ignore, or FailComponent). Insert Null: Insert Null in place of negative infinity. User defined: Insert a user-defined value in place of negative infinity. |
NegInf UD Value | The user-defined value to use in place of negative infinity. |
GreaterRange (>Max) Method | If the column contains an out-of-range value that is greater than the maximum acceptable value, you can choose one of these handling methods: Not Used: Pass the value directly to SSIS without modification. In this case, mapping errors and value truncation is reported to SSIS, which applies the appropriate error or truncation handling method (Redirect, Ignore, or FailComponent). Insert Null: Insert Null in place of the exported value. User defined: Insert a user-defined value in place of exported. |
GreaterRange (>Max) Value | The user-defined value to use in place of the exported value. |
LessRange (<Min) Method | If the column contains an out-of-range value that is less than the minimum acceptable value, you can choose one of these handling methods: Not Used: Pass the value directly to SSIS without modification. In this case, mapping errors and value truncation is reported to SSIS, which applies the appropriate error or truncation handling method (Redirect, Ignore, or FailComponent). Insert Null: Insert Null in place of the exported value. User defined: Insert a user-defined value in place of the exported value. |
LessRange (<Min) Value | The user-defined value to use in place of the exported value. |