BL_MAXERRORS= LIBNAME Statement Option

Specifies the maximum number of rejected rows that are allowed in the load before the COPY command is canceled.

Valid in: SAS/ACCESS LIBNAME statement
Category: Bulk Loading
Default: 0
Data source: Microsoft SQL Server
Note: Support for this option was added in SAS 9.4M7.
See: BL_MAXERRORS= data set option

Table of Contents

Syntax

BL_MAXERRORS=value

Syntax Description

value

specifies the maximum number of rejected rows that are allowed in the load before the COPY command is canceled.

Details

This option is used to support bulk loading when you access Azure Synapse Analytics (SQL DW) using an Azure Data Lake Gen2 account.

Last updated: February 3, 2026