Column |
Name of the imported column. |
Handler |
Whether malformed values are checked by Aster Database or SSIS:
- Choose Error/Truncation to use SSIS checking. SSIS can handle the malformed values inside SSIS, but the performance is impacted.
- Choose Aster to use Aster checking, which has better performance than SSIS checking, but the malformed values are passed to Aster Database and cannot not be send back to SSIS for additional processing.
|
Error |
What to do in if a value is not supported by SSIS. Examples of unsupported values are Null, infinity and negative infinity values.
-
Fail Component: Causes the Aster Loader Destination component to fail.
-
Ignore: Ignores the error.
-
Redirect Row: Redirects the row with the unsupported value to the error output of the component, which can be a text file.
|
Truncation |
What to do in case loaded values are truncated.
-
Fail Component: Causes the Aster Loader Destination component to fail.
-
Ignore: Ignores the error.
-
Redirect Row: Redirects the row with the truncated value to the error output of the component, which can be a text file.
|