• You have to include MAXERRORS option in your BULK INSERT statement.

    The default MAXERRORS value is 10.

    Since you have only one error, it was not caught by the TRY CATCH block.

    So, in order to capture the error in catch block you change the MAXERRORS = 0

    [font="Calibri"]Raj[/font]