| Name | Description |
|---|---|
| Error Handling | |
| Advanced Malformed Row Log File | |
| File Name | Name of the log file to output. |
| Location Type | Location type. Choose Environment Variable if the path to the file is stored in an environment variable. Choose Folder Path if you want to specify the folder where the file is stored. |
| Environment Variable | Environment variable that contains the path to where the file is stored. |
| Folder Path | Path to the folder where the file is stored. Either enter the path or click the “...” button and select the folder. |
| SSIS Redirection Error Limit | Maximum numbers of rows that are redirected before failing the component. If you do not specify a value, no rows are redirected. |
| Total Aster Error Row Limit | Number of malformed rows reported by ncluster_loader before the component fails. This option is relevant when you choose Aster for the handling of malformed values. This option is useful when you choose to execute ncluster_loader at the end of each buffer (CLIExecuteMode). In this case, the ncluster_loader is called many times, and the number of malformed rows are accumulated for each ncluster_loader call until that number reaches the value specified by this parameter. |
| Total Error Row Limit | Total number of rows containing errors before failing the component. If you do not specify a value, the component fails if one error occurs. |
| Logging | |
| Include Thread | Whether to include the thread number in the error record. Whether to include the thread number in the error record. SSIS transfers data buffer by buffer, and each buffer might be handled by a different thread. |
| Include TimeStamp | Whether to include a timestamp in the error record. |
| LogPerformance | Whether to log the performance statistics as Information, including elapsed time for calling ncluster_loader and data transformation inside Aster SSIS Connector. |
| LogFile | |
| File Name | Name of the log file to output. |
| Location Type | Location type. Choose Environment Variable if the path to the file is stored in an environment variable. Choose Folder Path if you want to specify the folder where the file is stored. |
| Environment Variable | Environment variable that contains the path to where the file is stored. |
| Folder Path | The path to the folder where the file is stored. Either enter the path or click the “...” button and select the folder. |
| Logging Level |
OFF: Nothing is logged. FATAL: Only issues that cause component failure are logged. ERROR: Only errors are logged. WARN: Only warnings are logged. INFO: Only information messages are logged. ALL: All logging levels are included in the log file. |
| LoggingCaptureType |
toMemoryStream: Send the log file to the screen output. toDisk: Store the log file on the local disk. |
| Performance | |
| CLIExecuteMode | Execute mode of ncluster_loader at the end of processing all rows (AtEndOfRowSet) or at each buffer (AtEachBuffer). AtEndOfRowSet: Treats the entire loading task as a single transaction, but performance is impacted. AtEachBuffer: Divides the loading task into several transactions (one transaction per buffer), which results in better performance. |
| MaxCLIThreadNumber | Maximum number of parallel ncluster_loader threads. Default is 1. |