Specifies whether to get reports on rejected rows and the corresponding error file.
| Valid in: | SAS/ACCESS LIBNAME statement |
|---|---|
| Category: | Bulk Loading |
| Default: | NO |
| Data source: | Microsoft SQL Server |
| Note: | Support for this option was added in SAS 9.4M7. |
| See: | BL_LOG= LIBNAME option, BL_USE_LOG= data set option |
Table of Contents
specifies that a log that contains rejected rows and corresponding errors should be created during bulk loading. The log is stored in the location that is specified by the BL_LOG= option.
specifies not to create a bulk loading log.
If no log location is specified for BL_LOG=, then the bulk loading log is stored in the temporary location that is specified by BL_DEFAULT_DIR=. Make sure that you have permission to write to the log location.
This option is used to support bulk loading when you access Azure Synapse Analytics (SQL DW) using an Azure Data Lake Gen2 account. To obtain Write permission for an Azure Synapse Analytics location, you might need to obtain a Shared Access Signature. For more information, see your Azure documentation.