BCP not returning any rows

Question

Hi. I am trying to use the BCP tool in a process ( .NET console application)

There are times, when the data is getting passed, there are times the BCP is not passing any data. How to find if there is any error while the BCP is executing. I have tried the below code, but not been able to capture any error.

using (var process = new Process())
{
process.StartInfo.UseShellExecute = false;
process.StartInfo.CreateNoWindow = true;
process.StartInfo.RedirectStandardError = true;
process.StartInfo.RedirectStandardOutput = true;
process.StartInfo.FileName = "BCP";

            process.StartInfo.Arguments = "\"" + Query + " \" queryout " + "\"" + fileName.Trim() + "\"" + " -T -S " + servername + " -d " + dbinstance + " -b 1000 -c -C 65001 -t~";

               process.Start();
            process.BeginOutputReadLine();
            process.WaitForExit();
            string stderr = process.StandardError.ReadToEnd();
            console.writeline(stderr);

        }

How to capture the error ? Is the above method correct ? Thanks

Answer 1

Consider this approach:

. . .
process.Start( );
process.WaitForExit( );
int c = process.ExitCode;
if( c == 0 )
{
   Console.WriteLine( "Success" );
   . . .
}
else
{
   Console.WriteLine( "Error" );
   . . .
}

If you want to intercept and analyse the output text, including errors, then remove BeginOutputReadLine and use ‘string text = process.StandardOutput.ReadToEnd( )’.

Answer 2

In theory, if your argument is okay, the following code should get the correct result.

    static void Main(string[] args)  
    {  
        using (Process process = new Process())  
        {  
            ProcessStartInfo startInfo = new ProcessStartInfo();  
            startInfo.UseShellExecute = false;  
            startInfo.RedirectStandardOutput = true;  
            startInfo.RedirectStandardError = true;  
            startInfo.FileName = "CMD.exe";  
            startInfo.Arguments = "/c bcp -v";  
            process.StartInfo = startInfo;  
            process.Start();  

            string outputString = process.StandardOutput.ReadToEnd();  
            string errorString = process.StandardError.ReadToEnd();  

            Console.WriteLine(outputString );  
            Console.WriteLine(errorString );  
            Console.WriteLine();  
        }   
                    
        Console.WriteLine("Press any key to continue......");  
        Console.ReadLine();  
    }  

---

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.