The bcp utility does not return the correct value of the %ERRORLEVEL% variable on some errors in SQL Server 2000

Step to reproduce the problem

1. In a text editor, create a batch file that is named Out.bat, and then paste the following commands in the file:

   echo off 
   bcp pubs..authors out c:\authors.dat -T -n -S <ServerName>\<InstanceName>
   echo %ErrorLevel%
   

   Note <ServerName> and <InstanceName> represent the name of the computer and the instance name of SQL Server.
2. Create a batch file that is named In.bat, and then paste the following commands in the file:

   echo off 
   bcp pubs..authors in c:\authors.dat -T -n -S <ServerName>\<InstanceName>
   echo %ErrorLevel%
   

3. At a command prompt, run Out.bat.
4. At the command prompt, run In.bat.
   
   The value of the %ERRORLEVEL% variable is set to 0.

Back to the top