BL_LOG= LIBNAME Statement Option

Specifies the name of the error file where all errors are written when BULKLOAD=YES.

Valid in: SAS/ACCESS LIBNAME statement
Categories: Bulk Loading
Data Set Control
Alias: BCP_ERRORFILE=
Default: none
Requirement: To specify this option, you must first specify BULKLOAD=YES.
Data source: Microsoft SQL Server, ODBC
Note: Support for Microsoft SQL Server was added in SAS 9.4M7.
Tip: If you do not specify BL_LOG=, then errors are not recorded during bulk loading.
See: BL_LOG= data set option, BULKLOAD= LIBNAME option

Table of Contents

Syntax

BL_LOG=<'>file-name<'>

Required Argument

file-name

specifies the name of the designated log file.

Details

Microsoft SQL Server: 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