BL_MAXERRORS= Data Set Option

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

Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
Category: Bulk Loading
Default: LIBNAME option value
Data source: Microsoft SQL Server
Note: Support for this data set option was added in SAS 9.4M7.
See:

Table of Contents

Syntax

BL_MAXERRORS=value

Required Argument

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