title: TRY doesn't CATCH error in BULK INSERT
body: <p>Why in the following code TRY didn't catch the error and how can I catch this error?</p>
  
  <pre><code>BEGIN TRY
    BULK INSERT [dbo].[tblABC]
    FROM 'C:\temp.txt'
    WITH (DATAFILETYPE = 'widechar',FIELDTERMINATOR = ';',ROWTERMINATOR = '\n')
  END TRY
  
  BEGIN CATCH
    select error_message()
  END CATCH
  </code></pre>
  
  <p>I just get this:</p>
  
  <pre><code>Msg 4860, Level 16, State 1, Line 2
  Cannot bulk load. The file "C:\temp.txt" does not exist.
  </code></pre>