ERRORFILE and MAXERRORS option with BULK INSERT

DECLARE @SQLvarchar(2000)
DECLARE @FileToLoad varchar(100)
DECLARE @DestinationTableName varchar(50) 
DECLARE @StartingRow int
DECLARE @FormatFilevarchar(50)
DECLARE @ErrorLogFile  varchar(50)

SET @FileToLoad = '\\servername\foldername\test.txt' --This is the name and path of the file which is to be BULK INSERTED into the staging table
   
SET @DestinationTableName = 'STAGING_TABLE' --Name of the staging table into which data from .txt file need to be loaded
 
SET @StartingRow = 2 --Tell us about the starting row in text file which needs to be loaded into staging table. 1st row is left as header
                  
SET @FormatFile = '\\servername\Format_file\test.fmt' --path and name of the format file.Format file with extension.fmt is used to define the mapping between text file columns and staging table columns
  
SET@ErrorLogFile  = '\\servername\TestErrorLog.txt' --path and name of the errorlog file.Records rejected during Bulk Insert will be saved in this error log file                       

SELECT @SQL = 'BULK INSERT DATABASENAME.dbo.' + @DestinationTableName + ' FROM ''' + @ FileToLoad + ''' 
WITH (FIRSTROW = ' + RTRIM(STR(@StartingRow)) + ', 
MAXERRORS = 500,
FORMATFILE = ''' + @FormatFile + ''',
ERRORFILE =''' + @ ErrorLogFile + ''',
) '
EXECUTE (@SQL)